if function shows 0 instead of blank
Dave,
You might care to explain how F38 can be both "" and "YES" (2nd example, the
one with the missing comma) <bg
--
__________________________________
HTH
Bob
"Dave Curtis" wrote in message
...
Hi,
it depends on what you are trying to achieve.
Try =IF(F38<"","",IF(F38="YES",C25,""))
or maybe
=IF(AND(F38="",F38="YES")C25,"")
Dave
"Wanna Learn" wrote:
Hello this is my formula =IF(F38=" "," ",IF(F38="YES",C25,FALSE)) I
do
not get the result I want. If F 38 is blank it shows a 0 .I do not want
the
zero I want it to be blank thanks
|