| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show value anyway
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 |
|
#2
|
|||
|
|||
|
Hi
=IF(ISNUMBER(J33),E33-J33,IF(ISNUMBER(E33),E33,"")) But what about case where J33 contains a numeric value, but E33 doesn't? Maybe =IF(AND(ISNUMBER(J33),ISNUMBER(E33)),E33-J33,IF(ISNUMBER(E33),E33,"")) Arvi Laanemets "Pat" wrote in message ... 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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
