View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default I WantTo Get Rid Of #Value

Do you have a formula in L14 that might be returning a blank ("")?

Try this:

=IF(ISNUMBER(L14),IF(L14<=0,0,L14-M14),"")

Biff

"Gatsby" wrote in message
...
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)