Hi,

I think what you want is:

=IF(E22=3,IF(O223,"NC", "C"))

and

=IF(E22=10,IF(O2210,"NC", "C"))

The question is what do you want to display if E22 does not equal 3 or 10?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"watermt" wrote:

I have a formula using the IF function and am having trouble making it work.
The formula:

Cell Q22
=IF(E22=3,IF(O223,"NC", "C"),IF(O22<3,"C", "NC"))

Cell R22
=IF(E22=10,IF(O2210,"NC", "C"),IF(O22<10,"C", "NC"))

What I'm trying to do is show either "C" or "NC" in cell Q22 (for number 3
selected in cell E22) or R22 (for number 10 selected in cell E22).

If cell Q22 displays "C" or "NC", I want cell R22 to remain blank; If cell
R22 displays "C" or "NC", I want cell Q22 to remain blank.

I hope this makes sense, I tried to and an OR function but it said I had too
many variables for this function. can someone help me with this?

Thanks,
Mike