Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank date shows up as s 1/0/00 | Excel Worksheet Functions | |||
Shows blank worksheet but ok in print preview | Excel Discussion (Misc queries) | |||
function results shows 0 | Excel Worksheet Functions | |||
My Excel 2000 shows 97 worksheets grey-blank - help!? | Excel Discussion (Misc queries) | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) |