Spreadsheet: 826158d1681832230-nested-if-statment-sample_if_statement_041823-aligw
Sheet: SAMPLE

Row Labels | FILE | SYSTEM | variance | LOGIC | AliGW
7066040 | 8525000 | 8525000 | 0 | see variance
7021005 | 5275000 | 4200000 | -1075000 | see variance
7021010 | 4275972 | 8338192.94 | 4062220.94 | see variance
7066005 | 2855168.5632 | 5620531.67 | 2765363.1068 | see variance
7093156 | 2636812 | 0 | -2636812 | booked in file, not system
7092325 | 357714.9894 | 817213 | 459498.0106 | see variance
7093355 | 339000 | 328500 | -10500 | see variance
7093315 | 290029.304 | 295098.35 | 5069.045999999973 | see variance
7066085 | 242102.0968 | 232521.64 | -9580.456799999985 | see variance
7092315 | 206881.1214 | 181348 | -25533.1214 | see variance
7093535 | 191250.1296 | 131846 | -59404.12959999999 | see variance
7093154 | 109236 | 0 | -109236 | booked in file, not system
7093405 | 88651.6142 | 354572.24 | 265920.6258 | see variance
7093505 | 81410 | 390314 | 308904 | see variance
7044005 | 73860 | 0 | -73860 | booked in file, not system
7044010 | 59088 | 0 | -59088 | booked in file, not system
7032115 | 36525 | 77034 | 40509 | see variance
7093425 | 35422.1786 | 215046.53 | 179624.3514 | see variance
7032205 | 32183 | 68285 | 36102 | see variance
7081005 | 8148 | 267687 | 259539 | see variance
7031110 | 0 | 3462936.88 | 3462936.88 | booked in system, not file
7093105 | 0 | 2434653 | 2434653 | booked in system, not file
7054055 | 0 | 1207000 | 1207000 | booked in system, not file
7093544 | 0 | 951871 | 951871 | booked in system, not file
7031215 | 0 | 751745.75 | 751745.75 | booked in system, not file
7065005 | 0 | 510850 | 510850 | booked in system, not file
7057025 | 0 | 441049 | 441049 | booked in system, not file
7042020 | 0 | 310318 | 310318 | booked in system, not file
7091030 | 0 | 218427 | 218427 | booked in system, not file
7093542 | 0 | 213086 | 213086 | booked in system, not file
7093510 | 0 | 159552 | 159552 | booked in system, not file
7051005 | 0 | 150262 | 150262 | booked in system, not file
7031105 | 0 | 130693 | 130693 | booked in system, not file
7053027 | 0 | 112250 | 112250 | booked in system, not file
7053025 | 0 | 101000 | 101000 | booked in system, not file
7093520 | 0 | 89895 | 89895 | booked in system, not file
7031140 | 0 | 75397.54 | 75397.54 | booked in system, not file
7093130 | 0 | 58175 | 58175 | booked in system, not file
7042015 | 0 | 49190 | 49190 | booked in system, not file
7053035 | 0 | 39902 | 39902 | booked in system, not file
7021025 | 0 | 38550 | 38550 | booked in system, not file
7092305 | 0 | 34375 | 34375 | booked in system, not file
7093515 | 0 | 24834 | 24834 | booked in system, not file
7021155 | 0 | 1312.34 | 1312.34 | booked in system, not file
8240465 | 0 | 0 | 0 | no action needed
7021020 | 0 | 0 | 0 | no action needed
7042005 | 0 | 0 | 0 | no action needed
7052010 | 0 | 0 | 0 | no action needed
7053010 | 0 | 0 | 0 | no action needed
7057035 | 0 | 0 | 0 | no action needed
7057066 | 0 | 0 | 0 | no action needed
7062005 | 0 | 0 | 0 | no action needed
7066055 | 0 | 0 | 0 | no action needed
7066065 | 0 | 0 | 0 | no action needed
7072010 | 0 | 0 | 0 | no action needed
7073005 | 0 | 0 | 0 | no action needed
7073010 | 0 | 0 | 0 | no action needed
7093110 | 0 | 0 | 0 | no action needed
7093115 | 0 | 0 | 0 | no action needed
7093158 | 0 | 0 | 0 | no action needed
7093360 | 0 | 0 | 0 | no action needed
7093365 | 0 | 0 | 0 | no action needed
7093540 | 0 | 0 | 0 | no action needed
7093546 | 0 | 0 | 0 | no action needed
8240455 | 0 | 0 | 0 | no action needed
8240465 | 0 | 0 | 0 | no action needed
7031115 | 0 | -102024.87 | -102024.87 | booked in system, not file
IF THERE IS A VALUE <> 0 IN B AND C, RESULT = SEE [NAME]
IF THERE IS A VALUE <> 0 IN B AND C IS 0, RESULT = booked in file, not system
IF THERE IS A 0 IN B AND C <> 0, RESULT = booked in system, not file
IF BOTH B & C ARE 0, RESULT = NO ACTION REQUIRED