Modifying a formula to display the results of another formula

G

Guest

I am using this formula

Formula1
=IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1));"";IF(OR(ISNA(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.
 
J

JulieD

Hi Carl

is this what you're after?
=IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1&$B$1));"";IF(OR(ISNA(C2);D2=2);"";A1&$B$1))CheersJulieD"carl" <[email protected]> wrote in messageam using this formula>> Formula1> =IF(ISNA(IF(OR(ISNA(C2);D2=2);"";A1));"";IF(OR(ISNA(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.>>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
vlookup returning Errors (ISNA formula) 3
match formula 2
Excel Need Countifs Formula Help 0
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8% 4
NETWORKDAYS Formula 1
Whats better Lookup or Function Formula 3

Top