| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if/then formula
How do i make a formual for if/then using text?
Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if/then formula
=IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building
B","124 Building B street, no town, FL.","")) where does phone fit in? -- __________________________________ HTH Bob "Len" wrote in message ... How do i make a formual for if/then using text? Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if/then formula
The phone would just be another cell of information that is auto completed.
If I put in the name of the company in column A, then the address would auto appear in then next column B, then the phone number would auto appear in the next column C. "Bob Phillips" wrote: =IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building B","124 Building B street, no town, FL.","")) where does phone fit in? -- __________________________________ HTH Bob "Len" wrote in message ... How do i make a formual for if/then using text? Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if/then formula
Thanks for the help Bob, I figured it out
"Bob Phillips" wrote: =IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building B","124 Building B street, no town, FL.","")) where does phone fit in? -- __________________________________ HTH Bob "Len" wrote in message ... How do i make a formual for if/then using text? Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if/then formula
Ok, it worked for the 2 arguments as listed below. Is there any way to add
more 2 arguments? I get an error if I add more than 2 argumtents. "Bob Phillips" wrote: =IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building B","124 Building B street, no town, FL.","")) where does phone fit in? -- __________________________________ HTH Bob "Len" wrote in message ... How do i make a formual for if/then using text? Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if/then formula
Create a two column table of lookup values and results, and use
=VLOOKUP(C2,M2:N10,2,False) -- __________________________________ HTH Bob "Len" wrote in message ... Ok, it worked for the 2 arguments as listed below. Is there any way to add more 2 arguments? I get an error if I add more than 2 argumtents. "Bob Phillips" wrote: =IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building B","124 Building B street, no town, FL.","")) where does phone fit in? -- __________________________________ HTH Bob "Len" wrote in message ... How do i make a formual for if/then using text? Example If cell C = Building A then cell E = 123 Building A street, no town, FL. then cell F = phone # If cell C = Building B then cell E = 124 Building B street, no town, FL. then cell F = phone # Get the idea? Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
