Conditional text display
 

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

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

Conditional text display
 

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

<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