Can anyone give me some help here?
The cells I am working with:
A1 cell is a numerical value - titled Square Footage (this value varies)
B2 cell is an alpha character value - titled Project Types (there could be multiple project types separated by a comma in the cell - the values could either be: warehouse, apartment, schools
I need a formula which multiplies A1 by B2. and -- if warehouse is found in B2 cell then multiply by 100, if apartment is found multiply by 200, if schools is found multiply by 225)
This may seem simple....but my skills as you can tell are not advanced. Any help is greatly appreciated.
The cells I am working with:
A1 cell is a numerical value - titled Square Footage (this value varies)
B2 cell is an alpha character value - titled Project Types (there could be multiple project types separated by a comma in the cell - the values could either be: warehouse, apartment, schools
I need a formula which multiplies A1 by B2. and -- if warehouse is found in B2 cell then multiply by 100, if apartment is found multiply by 200, if schools is found multiply by 225)
This may seem simple....but my skills as you can tell are not advanced. Any help is greatly appreciated.