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?
|