View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Spacebar creates value error

=IF(ISNUMBER(A1+A2),A1+A2,"")

Try that

"Dennis1188" wrote:

A3 is the sum total of A1 plus A2
If I clear either A1 or A2 with the spacebar I get a value error. I know I
can "clear the contents" or enter zero but is there another way around this
because using the spacebar is better for us.