| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Modifying a formula to display the results of another formula
I am using this formula
Formula1 =IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1));"";IF(OR(ISN A(C2);D2=2);"";A1)) C2 has the following formula: =A1&$B$1 If the conditions of Formula1 are true, the result seems to diplay the A1 value, not the concatentated value A1&$B$1. Is there a way to modify Formula1 to display the concatenated value ? Thank you in advance. |
|
#2
|
|||
|
|||
|
Hi Carl
is this what you're after? =IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1&$B$1));"";IF(O R(ISNA(C2);D2=2);"";A1&$B$1))CheersJulieD"carl" wrote in ...I am using this formula Formula1 =IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1));"";IF(OR(ISN A(C2);D2=2);"";A1)) C2 has the following formula: =A1&$B$1 If the conditions of Formula1 are true, the result seems to diplay the A1 value, not the concatentated value A1&$B$1. Is there a way to modify Formula1 to display the concatenated value ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
Linear Mode
