Re: rounding off numbers with excel

=ROUND(B215*F215/0.05,0)*0.05
in cell G125

--
Greetings from New Zealand
Bill K
"Tom C" <c_tom@xxxxxxxxxx> wrote in message
news:O4EaJJR%23FHA.1988@xxxxxxxxxxxxxxxxxxxxxxx
>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
>>
>
>


.

Loading