| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to the cell as it is empty...
when i use a formula like: if(A1=2,"ok","") in cell B1.
Is there a way to write the formula in other way that in case A1<2 my cell will be empty? i'll explain what i mean... before i added the formula to cell B1 it was empty(not in use). other cells that refers to B1 saw him as a zero value. after i used my formula it is not a zero any more... it is "". but i do not want to change the formula to be if(A1=2,"ok",0) since i have conditional format if the value is 0. i need the formula if(A1=2,"ok",????) to represent a clear cell... how should i do that? thanks Miri Tz. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
| How do I refer to a non-empty row range in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
