ExcelBanter - Multiple Condition Text Return

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Condition Text Return (https://www.excelbanter.com/excel-worksheet-functions/125060-multiple-condition-text-return.html)

Multiple Condition Text Return

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

Multiple Condition Text Return

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

"Gymclass14 via OfficeKB.com" <u26166@uwe wrote in message
news:6be8220edaa04@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1