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