| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Hi
try in this case =N(E33)-N(J33) "Pat" wrote: If J33 contains a value a calculation will be performed and a result will be returned =IF(ISNUMBER(J33),E33-J33,"") If J33 does not contain a value no calculation will be performed and no value will be returned. However if E33 contains a value I would want the value in E33 returned. Anyone know if this is possible? Thank you if you can be of help. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Help me Please!! Need hyperlinks to show actual email address! | New Users to Excel | |||
| eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) | |||
| Show a date based on today | Excel Worksheet Functions | |||
Threaded Mode
