View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Adding a number with a formula

Hello,

I would like to add to functions to this formula:

=Input_Sheet!M3 (it currently put's out this result: 44247896)

I would like to add: 800704 to the result so it reads: 44247896-800704

and I would like to learn how to write this formula so that if it refers to
a blank cell it does not return an error (it remains blank as well.

Thanks for the help.
Jim