add an if 0 to a formula

[ammartino44]

Hello. How do I add an if zero return "" to this formula? When any of the resulting values return a zero, I want it to be "" instead. Thanks

=IF(COLUMNS($A:A)<ROWS($1:1),"",IF(COUNT($B14:B14)<=12,$A14*$AW$18,IF(COUNT($B14:B4)<=24,$B7*$AW$19,0))/12)

[XOR LX]

Hi,

Can't be certain what you mean without seeing a workbook, but perhaps:

=IF(COLUMNS($A:A)<ROWS($1:1),"",IFERROR(1/(1/(IF(COUNT($B14:B14)<=12,$A14*$AW$18,IF(COUNT($B4:B14)<=24,$B7*$AW$19,0))/12)),""))

Regards