LinkBack URL
About LinkBacks
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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks