Accessing the formula (NOT the result)

[jonesdk]

i have this forumla in a cell D6.

=IF(C6="Answer","Right","Wrong")

I want to create a column E with the answers

so I need cell E7 to extract the "Answer" text

 

[Max]

Not sure about any hidden gotchas,
but is there anything wrong with this ?

Put in E6: =C6
Copy down col E

But if what you want is
to extract only the "Right" answers

then try in E6:

=IF(D6="Right",C6,"")

Copy down col E

The above will extract only
the "Right" answers from col C to col E

--
Rgds
Max
xl 97

 

[jonesdk]

saying e6: = c6 will simple copy accross whatever the guess was.

using e6: =IF(D6="Right",C6,"") will copy only accross the righ
guesses.

i want to extract the right answer from the result colum, given by

d6: = IF(C6="right answer", "right", "wrong")

basically, how can i access this formula from another column.

so i can write e6: = MID(C6, FIND(C6, "=", ...

 

[Max]

Ahh, so you *have* edited your original post in
Excelforum.

[The edited version is pasted below for easy reference.
It's not apparent outside of Excelforum, btw]

ok, it's clearer now.

IMHO, what you want is not possible,
unless the formula in col C is converted to text.

I'd set up the worksheet this way ..

List all the correct answers to the questions in col E
first,

Then refer to col E in the IF formulas in col C

So if "Earth" is listed in E1, then

In D1: =IF(TRIM(C1)=E1,"Right","Wrong")

Adding TRIM() improves robustness in matching the answers,
just in case users accidentally type any leading or
trailing spaces [via spacebar] in their answers in col C

btw, just trash the above if it's not what you're after

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---

-------- begin edited original post -----
Last edited by jonesdk on 03-23-2004 at 12:20 AM

my worksheet looks a bit like this...

Num, Question, Guess, Result
1, "what planet do we live on?", "earth", "Right"

i have this forumla in cell D1.

=IF(C1="EARTH","Right","Wrong")

I want to create a column E with the correct answers

so I need cell E1 to extract the the text "EARTH" from
cell D1.

geddit?
---------- end of edited original post ---

 

[Max]

Typo in line:

Then refer to col E in the IF formulas in col C

should read as: