Excel 2007 : If statement - logic syntax

[Omegaman]

I am trying to make a logical expression that checks for one of 4 conditions, and returns a displayed value for each of those conditions, but returns an error message if one of those conditions is not met.

If cell C5 = "N", then C10 = "N", if C5="S", then C10 = "S", if c5="+", then c10="+", if c5="-", then c10="-", if C5 is not equal to one of the previous four conditions, then c10="C5 error"

Restated another way for clarity:

If c5=N,S,+,or -, then c10=c5, else c10="c5 error"

So, what is the proper syntax for this? Sorry that my jargon is not up to speed, this is the only way I know how to ask the question.Thanks for the help.

[Stuie]

Hi Omegaman,

A formula can not change the value in another formula which is the reason that this wont work.

I would either use a VBA procedure to check and make all cell value changes or use a formula in the cell you want to change.

Not sure if that makes sense, but hope it helps somehow

[VBA Noob]

Maybe

=IF(C5="N","N",IF(C5="S","S",IF(C5="+","+",IF(C5="-","-","C5 error!"))))

VBA Noob

[shg]

Or in C10, since you're using Excel 2007,

=IFERROR(LOOKUP(C5, {"-","+","N","S"}), "C5 error")

[Omegaman]

=IF(C5="N","N",IF(C5="S","S",IF(C5="+","+",IF(C5="-","-","C5 error!"))))

That worked perfect Noob! Thanks a lot. It's good to be smart 'cuz then you know stuff!!!

[teylyn]

Another possibility, no nesting if statements required ...

=IF(OR(C5="N",C5="S",C5="+",C5="-"),C5,"C5 error!")