28
edits
Changes
mLine 248:
Line 248: − =$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)&". " − − − =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 "))))
no edit summary
|$19.61
|$19.61
|}
|}