| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how set cell to blank?
I have a cell formula:
=IF(OR(ISBLANK(K10),ISBLANK(L10)),,L10-K10) Which makes the cell zero if either of k10 or l10 is blank, (and subtracts the two if not), but I want to make the cell blank rather than zero. Thanks again. |
|
#2
|
|||
|
|||
|
One way:
=IF(OR(ISBLANK(K10),ISBLANK(L10)),"",L10-K10) alternatively: =IF(COUNT(K10:L10)<2,"",L10-K10) In article , "Ian Elliott" wrote: I have a cell formula: =IF(OR(ISBLANK(K10),ISBLANK(L10)),,L10-K10) Which makes the cell zero if either of k10 or l10 is blank, (and subtracts the two if not), but I want to make the cell blank rather than zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I blank a cell until a ref cell has the correct data? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Empty Cell ( blank Cell ) | Excel Worksheet Functions | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| Go to first blank cell | Excel Worksheet Functions | |||
Hybrid Mode
