| 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! |
| 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 | |||
Threaded Mode
