Create a formula -

go1canon

New Member
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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

sunny102

Board Regular
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.

go1canon

New Member
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.

sunny102

Board Regular
Use this

IF(B2="warehouse",A1*100,IF(B2="apartment",A1*200,IF(B2="schools",A1*225,"")))

go1canon

New Member
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,"")))

sunny102

Board Regular
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,"")))

Magic!
Sunny102.

Replies
0
Views
1K
Replies
8
Views
2K
Replies
5
Views
649
Replies
2
Views
1K
Replies
16
Views
1K

1,191,123
Messages
5,984,774
Members
439,910
Latest member
Flyingjoblo

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.

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

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