Spreadsheet: 870986d1717454922-how-to-apply-if-function-to-show-a-certain-value-testting
Sheet: Main tab

 | Previous HW Rate | 0.06 |  | HW Rate | 0.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Error Checks:
 | [NAME] | SP |  | SW HW support? | Yes
 |  |  |  | Software rate | 0.15
 |  |  |  | Support tier:
 |  |  |  | [NAME] | SP
 |  |  |  | Full or Partial Renewal?
 |  |  |  | Renew-To Date | 2025-12-31 00:00:00 | Term (Months)
 |  |  |  | Existing Contract End Date | 2024-12-31 00:00:00
Sold-To Party | Customer PO | [NAME] | [NAME] | Part Number | Part Description | Qty | HL Qty | Currency | Total LP | Total SP | BI [NAME] | Adjusted LP | Adjusted SP | [NAME] | Maint Part | Part Class | Chgable | Annual Maintenance | Contract Expiry | [NAME] | Days to Renew | Prorated Maintenance | Exclude | Reason | Maint Override | Override Rate | Override Base | Adjusted Reason | Go Forward Annual | Previous Annual
[NAME] | 12345 | 00012345 | 1 | Server 1 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 2 | Server 2 | Program | 1 |  | USD | 56000 | 27300 |  | 27300 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 3 | Server 3 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 4 | Server 4 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 5 | Server 5 | Program | 1 |  | USD | 16200 | 6318 |  | 6318 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 6 | Server 6 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 7 | Server 7 | Program | 1 |  | USD | 75000 | 65000 |  | 65000 |  | HW |  |  |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 8 | Server 8 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 9 | Server 9 | Program | 1 |  | USD | 89700 | 34983 |  | 34983 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 10 | Server 10 | Program | 1 |  | USD | 11200 | 0 |  | 0 |  | SW |  | Software | Y |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 11 | Server 11 | Program | 2 |  | USD | 2500 | 975 |  | 975 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 12 | Server 12 | Program | 1 |  | USD | 36800 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 13 | Server 13 | Program | 1 |  | USD | 240 | 156 |  | 156 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 14 | Server 14 | Program | 1 |  | USD | 230 | 149.5 |  | 149.5 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 15 | Server 15 | Program | 1 |  | USD | 260 | 169 |  | 169 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 16 | Server 16 | Program | 1 |  | USD | 1560 | 633.75 |  | 633.75 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 17 | Server 17 | Program | 1 |  | USD | 2850 | 1111.5 |  | 1111.5 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 18 | Server 18 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 19 | Server 19 | Program | 1 |  | USD | 56000 | 27300 |  | 27300 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 20 | Server 20 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 21 | Server 21 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 22 | Server 22 | Program | 1 |  | USD | 16200 | 6318 |  | 6318 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00
[NAME] | 12345 | 00012345 | 23 | Server 23 | Program | 1 |  | USD | 0 | 0 |  | 0 |  | SW |  | Software |  |  | 2024-12-31 00:00:00 | 2025-12-31 00:00:00