Re: rounding off numbers with excel

the /0.05 changes it to units of 5 cents, the number of 5 cents in the
amount
the , 0 rounds that number to 0 decimal; places
the *0.05 returns it to original units

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tom C" <c_tom@xxxxxxxxxx> wrote in message
news:OpQg9WR%23FHA.3608@xxxxxxxxxxxxxxxxxxxxxxx
> I really appreciate the help, and I hate to be so bothersome, but could
you
> help me break this down
> I know it is multiply B215 X F215. and I am guessing divide that by .05
> which is 5 cents? What is the ,0 and the *0.05
>
>
>
> "Bill Kuunders" <bill.kuunders@xxxxxxxxxx> wrote in message
> news:%23kTirNR%23FHA.360@xxxxxxxxxxxxxxxxxxxxxxx
> > =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
> >>>
> >>
> >>
> >
> >
>
>


.