Dividing then Multiplying in One Cell

[H7H12]

Hi there,

My question is as follows: I have data which I need to divide, then multiply by a percentage.

For example: I wish to divide A1 by B1, then multiply this total by a percentage in C1. Preferably, I would like to do all of this in one cell.

I have been trying A1/B1*C1, but I believe I need to seperate the first calculation from the second one?

Is this relatively easy to do? Any help would be appreciated! I am using Excel 2007 and happy to provide any further information.

 

[VoG]

That formula works fine

Excel Workbook
	A	B	C	D
1	100	10	10%	1
Sheet4

 

[Aladin Akyurek]

Looks like you are after one of these...

=(A1/B1)*C1

=(A1/B1)*(1+C1)

 

[JackDanIce]

It's not clear what you are trying to do, an example may be easier to help solve.

However,

=A1/B1*C1

Is mathematically identical to

=(A1/B1)*C1

Since a division operation supersedes a multiplication one

 

[H7H12]

Hi there,

Thank you for such a quick response. It seems my method is therefore incorrect, as opposed to the formula used.

Essentially, I want the following:

A1/B1 + C1 (C1 is a percentage of the total of A1/B1).

So, if A1 is 400, B1 is 0.75 and C1 is 20%, I want to first do the following:

400/0.75

Then work out what 20% of this figure is and add it within the cell, giving me a total of 640.

Apologies if this isn't very clear - Mathematics has never been my strong point, unfortunately.

 

[JackDanIce]

Ty:

=(A1/B1)*(1+C1)

This is what Aladin suggested in his post

 

[Desu Nota from Columbus]

Hi there,

Thank you for such a quick response. It seems my method is therefore incorrect, as opposed to the formula used.

Essentially, I want the following:

A1/B1 + C1 (C1 is a percentage of the total of A1/B1).

So, if A1 is 400, B1 is 0.75 and C1 is 20%, I want to first do the following:

400/0.75

Then work out what 20% of this figure is and add it within the cell, giving me a total of 640.

Apologies if this isn't very clear - Mathematics has never been my strong point, unfortunately.

JackDanIce's formula does this exactly.


=(A1/B1)*(1+C1)</pre>

 

[H7H12]

Perfect! Thank you so much, JackDanIce, Desu Nota and Aladin!

Hope you don't mind me asking, but can you recommend anywhere where I can read about what's happening within the formula, with the *(1+C1)? The name of the calculation will be great - Just so I can learn more about it!

 

[Desu Nota from Columbus]

Perfect! Thank you so much, JackDanIce, Desu Nota and Aladin!

Hope you don't mind me asking, but can you recommend anywhere where I can read about what's happening within the formula, with the *(1+C1)? The name of the calculation will be great - Just so I can learn more about it!

It is just math!

You wanted to get 20% of the total, then add it to the value A1/B1;doing this method requires two steps.

Example:

1) 400/.75 = 533.33

2) 20% of 533.33 is the same as saying 533.33*0.20 = 106.66

3) 533.33 + 106.66 = 640


instead:

1) 400/7.5 = 533.33

2) 533.33*(1+20%) which is 533.33*(1+0.20) = 640

Equation two is saying essentially multiply 533.33 by 120% (or by 100% + 20%).





If you want to give this a name it would be the distributive property (I guess ) A(B+C) = AB + AC


533.33(1+0.20) = 533.33(1) + 533.33(0.20) = 533.33 + 106.66 = 540

Hope that clarifies it!

 

[H7H12]

Wonderful - thank you! Told you my maths wasn't very good .