Re: rounding off numbers with excel

I appreciate ya'lls help. Let me explain a l;ittle deeper so I will know
where to put this formula. I dont want to mess up my spread ***, i am
kinds new to formulas.
I am doing a pread*** for my gas mileage.
I have a column with the gallons used, i'll call that cell B-215
I have a column with the Price per gallon, cell F-215
In cell G-215 i wrote a formula that goes like this =B215*F215
That formula multiplies the cells and gives me the dollar amount, but i also
would like it to round it off up or down to the nearest nickle.
Can i have the round formula with my multiplying formula or do i need to use
another cell for a formula. I hope this makes since,,and i do appreciate the
help.....Tom



"Tom C" <c_tom@xxxxxxxxxx> wrote in message
news:Oxbm9rQ%23FHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
> If i have a number such as 19.57, how can i get Excel (Office XP) to round
> it off to the nearest 100th. To where it would be 19.55 or if the number
> was 19.58, i would want it to round up to 19.60.
> Thanks for the help...Tom
>


.