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

if function shows 0 instead of blank
 

You don't need a nested if statement for this, try the following:

=IF(F38="YES",C25,"")
--
Kevin Backmann


"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

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

if function shows 0 instead of blank
 

Try this:

=IF(ISBLANK(F38)," ",IF(F38="YES",C25,FALSE))

John

"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

if function shows 0 instead of blank
 

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

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

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.