Multiple Condition Text Return

[Gymclass14 via OfficeKB.com]

I am trying to get text to appear when a certain numerical amount is
entered. If the value in A3 is greater than and equal to 30,000 the return
is "Standard. If A3 is greater than or equal to 30,001 the return is
"Incentive". If A3 is greater than or equal to 42,000 the return is "Elite".
The text must appear in cell F3. Its confusing, but please help. Thanks in
advance.

 

[T. Valko]

This formula does what you want:

=IF(A3>=42000,"Elite",IF(A3>=30001,"Incentive",IF(A3>=30000,"Standard","")))

But.....is this a typo:

If the value in A3 is greater than and equal to 30,000 the return
is "Standard. If A3 is greater than or equal to 30,001 the return is

Biff