=IFInput_Sheet'!M3="","",M3 & "-800704")


Gord Dibben MS Excel MVP


On Thu, 3 Sep 2009 06:51:01 -0700, Jim
wrote:

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