Conditional text display

[kumar kumar]

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/tutorial...3b-9953c1a0e807/pabzipcode-com-component.aspx

 

[T. Valko]

Kind of confusing!

My best guess...

Select cell B2
Enter this formula:

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

 

[David Biddulph]

=IF(A1=1,"B2=(1-50)",IF(A1=2,"B2=(50-100)","whatever you want to display if
A1 is neither 1 nor 2"))