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 >