Thread: if function shows 0 instead of blank
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default if function shows 0 instead of blank
=IF(F38="","",IF(F38="YES",C25,FALSE))


--
__________________________________
HTH

Bob

"Wanna Learn" wrote in message
...
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



Reply With QuoteReply With Quote