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

Hi TOm

That's not 100th, it's 20th. With your number in A1, formula in B1:
=ROUND(A1/5,2)*5

HTH. Best wishes Harald

"Tom C" skrev i melding
...
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

=ROUND(A1*20,0)/20

--

HTH

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


"Tom C" wrote in message
...
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

Looks like you want to round to the nearest 5 cents

If A1 is the number enter in B1.................
=ROUND(A1/0.05,0)*0.05

format B1 as number with two decimals
--
Greetings from New Zealand
Bill K
"Tom C" wrote in message
...
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

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 sheet, i am
kinds new to formulas.
I am doing a preadsheet 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" wrote in message
...
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

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

--
Greetings from New Zealand
Bill K
"Tom C" wrote in message
...
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 sheet, i am
kinds new to formulas.
I am doing a preadsheet 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" wrote in message
...
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

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" wrote in message
...
=ROUND(B215*F215/0.05,0)*0.05
in cell G125

--
Greetings from New Zealand
Bill K
"Tom C" wrote in message
...
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 sheet, i am
kinds new to formulas.
I am doing a preadsheet 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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
=ROUND(B215*F215/0.05,0)*0.05
in cell G125

--
Greetings from New Zealand
Bill K
"Tom C" wrote in message
...
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 sheet, i am
kinds new to formulas.
I am doing a preadsheet 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" wrote in message
...
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