Just a quick one, I have an equation question and the formula below:

if(G1_Q0013 == 'A3', 'Correct', 'Incorrect') if(G1_Q0013 == 'A4', 'Correct', 'Incorrect') if(G1_Q0013 == 'A5', 'Correct', 'Incorrect')

This will give the text answer of (correct, incorrect, incorrect) or a variation of this in a different order
or it could display (incorrect,incorrect,incorrect).

Is there a way i can alter the formula above to only display one answer? That being correct or incorrect.

Cheers

Hi, stermate1988,
you get three answers because you have three conditions.

Remember how the "IF" works:
IF (some_condition, result if true, result if false).

So you have to merge your IF statements:
IF(G1_Q0013.NAOK=='A3', 'Correct', if(G1_Q0013.NAOK=='A4', 'Correct',if(G1_Q0013.NAOK=='A5','Correct','Incorrect'))).

But as I understand your statement:
If one the answers is 'A3' or 'A4' or 'A5' the result is 'Correct' otherwise 'Incorrect'.

So IMHO it's better just to say:
if(G1_Q0013.NAOK=='A3' or G1_Q0013.NAOK=='A4' or G1_Q0013.NAOK=='A4','Correct','Incorrect')

Best regards
Joffm

Cheers for this Joffm,

I knew there would be a way of constructing this using the OR operators i just couldnt work it out.
It works anyway.

Much appreciated