View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default if function shows 0 instead of blank

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


Though it looks the same, a cell with a "space" character in it is
different from a cell that's empty. Your formula is testing for one
"space" character only.

Also, if C25 is empty, the formula returns returns zero in the "YES" case.

To allow for unseen spaces in general, and to allow for C25="", you might
consider something like:
=IF(TRIM(F38)="","",IF(TRIM(F38)="YES",IF(TRIM(C25 )="","",C25),FALSE))

The TRIM function is described in Excel's built-in Help.