Thread: if/then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
len len is offline
external usenet poster
 
Posts: 53
Default 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?