Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I WantTo Get Rid Of #Value
I want Cell N14 to complete ONLY when the entry is made in Cell L14.
Otherwise I want it blank. If I don't have anything in Cell L14, I'm getting #VALUE, in N14. This continues all the way down to Column N60, until I make an entry in the 'L's'. This is the formula I'm using which is obviously wrong: =IF(L14<=0,0,(L14-M14)) Help please? Gatsby (Not The Great) |