rounding off numbers with excel
 

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

rounding off numbers with excel
 

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

rounding off numbers with excel
 

=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

rounding off numbers with excel
 

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

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 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

rounding off numbers with excel
 

=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

rounding off numbers with excel
 

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

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" 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