How do i round up an answer in a cell that has a formula attached?

M

Monsta1266

I have copied a number from another worsheet onto a cell (G-5) on another
spreadsheet then typed a formula into a cell B5=G5/210 but the answer differs
from that as when i work it out on a calculator. I think the reason is the
decimal places that i have brought in from the other worksheet, but if i
check the number of decimal places, it is already set at 2 decimal places.
This is giving us a nightmare on an accounting system that we have which
differs in the final answer to the spreadsheet that we have.
Can anybody help me?
 
P

Pete_UK

Put this formula in B5:

=ROUND(G5/210,2)

If the cell is set with a format of 2 decimal places, this affects the
display of the number, not its value.

Hope this helps.

Pete
 

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

Excel does not accept text format! 0
IF and Round 5
how do i round a quotient to specific decimal places? 3
Round a repeating decimal from a formula... 14
A couple questions BEFORE using Office 365 0
drag formula down from columns that go acros 3
subtraction returning incorrect calue 5
Show a cell's formula in text format in a linked cell 2

Top