What am I doing wrong?

[Jeff]

Here is the formula I came up with but it doesn't do what I want it to.

=IF(C2>47.999,IF(D2>143.999,"22222",IF(C2<47.998,IF(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

 

[Dave Peterson]

You have one guess at your post in .misc.

Here is the formula I came up with but it doesn't do what I want it to.

=IF(C2>47.999,IF(D2>143.999,"22222",IF(C2<47.998,IF(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

 

[Bill Kuunders]

=IF(AND(C2>47.999,D2>143.999),"22222","33333")

Regards
Bill K

 

[Ken Wright]

=1111*(OR(C2<48,D2<144)+2)

 

[Jeff]

Thanks,
Jeff