| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a "0" when cell is empty
The following formula works good except for when there is no value in the
cell. What can I do to the formula to be "0" when the C22 has no value in the cell? =MIN(10,C22) C22 Formula Result 10 (It should be zero) 1 1 5 5 10 10 15 10 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need a "0" when cell is empty
Try this...
=IF(C22="",0,MIN(10,C22)) Rick "Don Lowe" wrote in message ... The following formula works good except for when there is no value in the cell. What can I do to the formula to be "0" when the C22 has no value in the cell? =MIN(10,C22) C22 Formula Result 10 (It should be zero) 1 1 5 5 10 10 15 10 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need a "0" when cell is empty
=IF(C22="",0,MIN(10,C22))
Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Empty a cell if the values equal to "IN" , "MC" or "PP" | Excel Programming | |||
| delete rows if cell in row contains "a" or "o" or empty | Excel Programming | |||
| STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST | Excel Programming | |||
| Excel: can "go to adjacent empty cell" double-click be disabled? | Excel Discussion (Misc queries) | |||
Linear Mode
