Line 248: |
Line 248: |
| |$19.61 | | |$19.61 |
| |} | | |} |
− | {|
| + | =$U$21&AM5#&"represent "&IF(--(AN5#+AP5#=0)+--(AO5#+AQ5#=0)>0,"an annualized total ","an annualized net ")&IF((AN5#+AO5#+AP5#+AQ5#)>0,"cost",IF((AN5#+AO5#+AP5#+AQ5#)<0,"cost savings","")) |
− | !=$U$21&AM5#&"represent "&IF(--(AN5#+AP5#=0)+--(AO5#+AQ5#=0)>0,"an annualized total ","an annualized net ")&IF((AN5#+AO5#+AP5#+AQ5#)>0,"cost",IF((AN5#+AO5#+AP5#+AQ5#)<0,"cost savings",""))
| |
| | | |
| &" of "&DOLLAR(ABS($AN5#+AO5#+AP5#+AQ5#),0)&". " | | &" of "&DOLLAR(ABS($AN5#+AO5#+AP5#+AQ5#),0)&". " |
− | !=LET(BizCount, MAXIFS($AJ5#,$W5#,$AM5#,$X5#,"In",$Y5#,"Labour",AJ5#,">0"),IF(BizCount=1,"One Business would spend ",IF(BizCount=0,"", IF(BizCount<10, "Up to " &INDEX(tbl_NumberWord,BizCount,2) & " businesses would spend ", "Up to " & ROUND(BizCount,0) & " businesses would spend "))))
| + | |
− | !
| + | |
− | !
| + | =LET(BizCount, MAXIFS($AJ5#,$W5#,$AM5#,$X5#,"In",$Y5#,"Labour",AJ5#,">0"),IF(BizCount=1,"One Business would spend ",IF(BizCount=0,"", IF(BizCount<10, "Up to " &INDEX(tbl_NumberWord,BizCount,2) & " businesses would spend ", "Up to " & ROUND(BizCount,0) & " businesses would spend ")))) |
− | |}
| |