Ask Experts Questions for FREE Help !
Ask
    crosstopher's Avatar
    crosstopher Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Apr 18, 2008, 08:35 PM
    Rounding Down
    I have an extremely basic spreadsheet that I need to stop rounding and just look at numbers as having two decimal places.

    I'm taking a currency gross and multiplying by 3%

    then subtracting the 3% from the gross

    My problem comes in when Excel looks at the number as having more than one decimal place and rounds up anyway, thus adding an extra .01 instead of just dropping it.

    Here are my formulas please tell me of any solutions that may fix it or holes in my formulas.

    =(C3*.03) to get my 3%

    =(C3-D3) to get my Net

    The cells are formatted to currency with 2 decimal places.

    thanks
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #2

    Apr 19, 2008, 06:10 AM
    I believe the answer is to use the ROUND function in your calculations.

    =ROUND(C3*.03,2)

    You may want to round the product as well:

    =ROUND(C3-D3,2)
    crosstopher's Avatar
    crosstopher Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Apr 19, 2008, 10:34 PM
    Works perfect, thanks!
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Rounding to the nearest 1/2 inch and inch [ 4 Answers ]

Sarah was asked to round 4 7/8 in to the nearest 1/2 inch and to the nearest inch. Her answer was the same. Explain why Sarah is correct. Would it be 5 inches. :)

Stop Excel from Rounding [ 1 Answers ]

I have created a Timesheet spreadsheet, in Excel, that calulates the amount of time between to manually entered times. This is the formula I am using =IF((OR(D8="";B8=""));0;IF((D8<B8);((D8-B8)*24)+24;(D8-B8)*24)) The formula works very well and does return the corrent amount of elapsed...

Rounding numbers to specific criteria [ 3 Answers ]

Hi, I am working on spreadsheets with values that I want to be able to round up based on this criteria: If the number ends in 0,1,2, then round to nearest 0 If the number ends in 3,4,5, then round to nearest 5 If the number ends in 6,7,8,9 then round to nearest 9 The spreadsheet contains...

Excel rounding [ 1 Answers ]

ELATHAM How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong. My figures need to balance right to the penny. Thank you, Estrella

View more questions Search