View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gymclass14 via OfficeKB.com Gymclass14 via OfficeKB.com is offline
external usenet poster
 
Posts: 8
Default 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