Thread
:
Returning nothing if formula is false
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave O
external usenet poster
Posts: 427
Returning nothing if formula is false
One way to do this is to change the formulas to include IF formulas,
like this:
IF(your original formula=0,"",your original formula)
This will return an empty cell if the original formula yields a zero.
Reply With Quote
Dave O
View Public Profile
Find all posts by Dave O