Thread: Conditional text display
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Conditional text display
Kind of confusing!

My best guess...

Select cell B2
Enter this formula:

=IF(A1=1,"1 - 50",IF(A1=2,"50 - 100",""))

--
Biff
Microsoft Excel MVP


<kumar kumar wrote in message ...
I need some help doing this. Am using office 2000. I want to display a text
based on two conditions.
If A1 = 1 then display B2=(1 - 50) or if A1=2 then display B2=(50 - 100).

Thanks.

EggHeadCafe - Software Developer Portal of Choice
PABZipCode COM Component and Database
http://www.eggheadcafe.com/tutorials...component.aspx


Reply With QuoteReply With Quote