| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula miscalculating blank cells
I am trying to create a conditional formula that will tag cells with data
points =0 as "1", if not =0, then a tag of "0". Excel is identifying blank cells as though they contained a zero and therefore tags these blank cells as a "1" when I need them to be reflected as a "0". Can anyone help / advise how to correct this. Thanks + happy new year |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formats to ignore blank cells | Excel Worksheet Functions | |||
| using conditional formatting - blank cells | Excel Discussion (Misc queries) | |||
| How can I count conditional blank cells? | Excel Worksheet Functions | |||
| Non-Blank Cells: Conditional Counting | Excel Worksheet Functions | |||
| Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
