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.

 

[JackDanIce]

If you divide by any number by something less than 1, your answer is larger,
e.g.
1 / 0.25 = 4 i.e. 4 > 1

Similarly, if you multiply a number by something less than 1, your answer is smaller,
e.g.
1 * 0.25 = 0.25 i.e 0.25 < 1

So to get a percentage increase, you need to add the percent to 1, i.e. 20% increase means multiply by 1 + 0.20 = 1.2

 

[Desu Nota from Columbus]

I made some edits after you posted...just drawing attention to them

 

[H7H12]

Thanks for explaining! Definitely need to brush up on my maths. Thanks ever so much for yr help.

 

[Aladin Akyurek]

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!

Gee. Interestin all that...

(A1/B1)*(1+C1)

is the shorter version of:

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

 

[H7H12]

Just to say thanks again, especially for providing the dividing/multiplying differences on percentages. I was able to spot an error in my spreadsheet - so thanks ever so much.

 

[Aladin Akyurek]

Just to say thanks again, especially for providing the dividing/multiplying differences on percentages. I was able to spot an error in my spreadsheet - so thanks ever so much.

You are welcome.