Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If" function and blank cells
I'm trying to create an If function where if the cell is equal to 0, then the
cell is populated with 1. However, I've discovered that the formula is not ignoring blank cells. Can I add a function for it to ignore blank cells? This is what I have so far: =IF('Performance Analysis'!J36 =0,1,"") Any help is appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If" function and blank cells
Try
=IF(AND('Performance Analysis'!J36<"",'Performance Analysis'!J36=0),1,"") If this post helps click Yes --------------- Jacob Skaria "lisab" wrote: I'm trying to create an If function where if the cell is equal to 0, then the cell is populated with 1. However, I've discovered that the formula is not ignoring blank cells. Can I add a function for it to ignore blank cells? This is what I have so far: =IF('Performance Analysis'!J36 =0,1,"") Any help is appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If" function and blank cells
=IF('Performance Analysis'!J36 =0,1,"")
Try this... =IF('Performance Analysis'!J36="","",IF('Performance Analysis'!J36=0,1,"")) -- Biff Microsoft Excel MVP "lisab" wrote in message ... I'm trying to create an If function where if the cell is equal to 0, then the cell is populated with 1. However, I've discovered that the formula is not ignoring blank cells. Can I add a function for it to ignore blank cells? This is what I have so far: =IF('Performance Analysis'!J36 =0,1,"") Any help is appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If" function and blank cells
try:
=IF(isblank('Performance Analysis'!J36)=true,"",if('Performance Analysis'!J36 =0,1,"")) -- hope to help, cm "lisab" wrote: I'm trying to create an If function where if the cell is equal to 0, then the cell is populated with 1. However, I've discovered that the formula is not ignoring blank cells. Can I add a function for it to ignore blank cells? This is what I have so far: =IF('Performance Analysis'!J36 =0,1,"") Any help is appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If" function and blank cells
I doubt whether you need the "=true".
ISBLANK returns a boolean TRUE or FALSE; comparing it with TRUE will return TRUE or FALSE respectively. Remember, of course, that ISBLANK will not be true if the cell contains an empty text string "". -- David Biddulph "cm" wrote in message ... try: =IF(isblank('Performance Analysis'!J36)=true,"",if('Performance Analysis'!J36 =0,1,"")) -- hope to help, cm "lisab" wrote: I'm trying to create an If function where if the cell is equal to 0, then the cell is populated with 1. However, I've discovered that the formula is not ignoring blank cells. Can I add a function for it to ignore blank cells? This is what I have so far: =IF('Performance Analysis'!J36 =0,1,"") Any help is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - how to collapse "non-blank" cells in a column? | Excel Discussion (Misc queries) | |||
How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |