Dividing then Multiplying in One Cell

Thanks:  0
Likes:  0

Thread: Dividing then Multiplying in One Cell

1. Dividing then Multiplying in One Cell

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.

2. Re: Dividing then Multiplying in One Cell

That formula works fine

Sheet4

 A B C D 1 100 10 10% 1

 Cell Formula D1 =A1/B1*C1

Excel tables to the web >> Excel Jeanie HTML 4

3. Re: Dividing then Multiplying in One Cell

Looks like you are after one of these...

=(A1/B1)*C1

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

4. Dividing then Multiplying in One Cell

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

However,
Code:
`=A1/B1*C1`
Is mathematically identical to
Code:
`=(A1/B1)*C1`
Since a division operation supersedes a multiplication one

5. Re: Dividing then Multiplying in One Cell

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.

6. Dividing then Multiplying in One Cell

Ty:
Code:
`=(A1/B1)*(1+C1)`
This is what Aladin suggested in his post

7. Re: Dividing then Multiplying in One Cell

Originally Posted by 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's formula does this exactly.

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

8. Re: Dividing then Multiplying in One Cell

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!

9. Re: Dividing then Multiplying in One Cell

Originally Posted by 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!

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

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!

10. Re: Dividing then Multiplying in One Cell

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

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•