|
|
| Multiple Condition Text Return |
|
| Author |
Message |
nemec
|
 Posted: Sat Jan 06 22:56:07 CST 2007 |
Top |
worksheet functions >> 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.hide-link.com/
Excel523
|
| |
|
| |
|
T
|
| Posted: Sat Jan 06 22:56:07 CST 2007 |
Top |
worksheet functions >> 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
> 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.aspx/excel-functions/200701/1
>
|
| |
|
| |
|
| |
|