Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.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.officekb.com/Uwe/Forums.a...tions/200701/1 |
#2
Posted to microsoft.public.excel.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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
look up multiple values, to return only one value | Excel Worksheet Functions | |||
Returning Multiple Text or Address Locations | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |