Dividing linked cells

A

Ana G

I have to get the total of a list of cells that have been linked and is
rounding the number.
I am dividing cells =c47/c48 which is 8831/33 and I get on C49=270
 
T

Toppers

Display the cells with 2 or more decimal places and I expect you will find
the data is not 8831 or 33 but something like 8831.51 and 32.73

=8831.49/32.7 will give an answer of 270 (270.08 to 2 decimal places) but
show as 8831 and 33 with no decimal places.

HTH
 

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

Top