Excel Excel 2007 won't stop rounding down my formula results!


Joined
May 19, 2017
Messages
4
Reaction score
1
Hello everyone,

I'm trying to use formulas to calculate some profit-sharing and excel won't stop rounding down the answers. I have 3 shareholders to share 12.5% of the total (for the purpose of this post, I'm using 100) and 16 others to share the remaining 87.5%.

Now, on paper (and using my trusty phone calculator), the first set of 3 shareholders should each get 4.166666% of the total while the second set should each get 5.46875%.

When I enter these as formulas, I get 4 and 5 respectively. Even if I change the cell format to number with 5 decimal places, all I get is 4.00000 and 5.00000. I've changed the format to general, text, currency, accounting, increased and decreased the number of decimal places, no joy.

Any suggestions will be highly appreciated, I'm at my wits' end!

Thank you!
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum :)

What formula are you using to calculate the profit share?
 
Joined
May 19, 2017
Messages
4
Reaction score
1
Hello Becky!

It's nothing complicated, I use the QUOTIENT formula and divide 12.5 by the number of shareholders, in this case, 3.

Thanks!
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Ah, well there's your issue. The quotient formula gives the integer of a division, which is why it appears to be rounded. Just do a calc instead - eg =A1/B1
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top