|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2009, 06:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
November 17th, 2009, 06:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
November 17th, 2009, 06:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
