Changes

m
Experiment with Power Queries
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 "))))
|}