Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding several number | New Users to Excel | |||
Adding a Number and Formula Text and Evaluating | Excel Worksheet Functions | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
Formula to stop adding at a positive number | Excel Worksheet Functions | |||
What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions |