Create a formula -

go1canon

New Member
Joined
Dec 26, 2016
Messages
4
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi,

As you have written that there can be multiple values in B2 separated by a comma, so what if B2 contains all the three values i.e., warehouse, apartment, schools or only 2 out of three then by which value should A1 be multiplied. Can you please elaborate on this.

I'm online and able to respond in real time to you until it's solved.

Thanks

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.
 
Upvote 0
Sunny2012 thanks for the response.
I did not explain properly. Sorry
B2 will only contain 1 of 3 possible values i.e., warehouse, apartment, schools
(B2 could contain any 1 of the 3 but one 1 at a time)
Thank you.
 
Upvote 0
Use this

IF(B2="warehouse",A1*100,IF(B2="apartment",A1*200,IF(B2="schools",A1*225,"")))
 
Upvote 0
I'm doing something wrong.
I changed the formula to this.....and the formula is not calculating - it's only displaying the formula as it appears below.
IF(B2="warehouse",A2*100,IF(B2="apartment",A2*200,IF(B2="schools",A2*225,"")))
 
Upvote 0
Apply = to sign before if, and make sure that project types are writtenas they are written in formula in small caps or change formula accordingly

=IF(B2="warehouse",A2*100,IF(B2="apartment",A2*200,IF(B2="schools",A2*225,"")))
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top