Changes

Jump to navigation Jump to search
m
no edit summary
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",""))
  −
  −
&" 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 "))))
 

Navigation menu

GCwiki