What am I doing wrong?

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

You have one guess at your post in .misc.

Jeff wrote:
>
> 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

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

Regards
Bill K



"Jeff" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jeff" <[email protected]> wrote in message
news:[email protected]...
> 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

Thanks,
Jeff