|
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com