Conditional text display

's Computer Specifications

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

's Computer Specifications

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 news:(E-Mail Removed)...
>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

's Computer Specifications

=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 news:(E-Mail Removed)...
>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format to display text alert	VSS	Microsoft Excel Worksheet Functions	3	6th Jun 2009 03:06 PM
Conditional Display of Text Box	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access	2	3rd May 2007 05:06 PM
Conditional Text Box Display	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access Forms	5	25th Apr 2007 10:58 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM
Conditional display of text in a query result	=?Utf-8?B?VHJhY3k=?=	Microsoft Access Queries	1	21st Oct 2004 10:50 PM