Formula Rounding

S

Starrlight341

I have a spreadsheet where I have a formula in a cell. The answer in that
cell needs to be round down instead of up. It's set to two decimal places
but the answers are different than my account because of rounding. How do I
had adda formula to the exsisting equation to have it round down?
 
P

Pete_UK

=ROUNDDOWN(your_formula,2)

will round down to 2 decimal places.

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

rounding a number up to a certain ending digit 6
Excel does not accept text format! 0
Transfer data between two tables 3
Excel - Wich Function should I use? 1
Rounding Up question 2
Newbie Help - IF Yes No Function 0
Round Function 5
Drop down list control value in vba 2

Top