Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Newbie: How to round down to the lowest 5
I am trying to write a formula that will allow me to round down the
lowest digit, say 5. For example if the value in A1= 1297.19 then the value in A2 should display 1295.00 also if the value in A1=632.67 then I would want to round down to 630.00. Can anyone help? Thanks |
#2
|
|||
|
|||
=5*ROUNDDOWN(A1/5,0)
Jerry Sam wrote: I am trying to write a formula that will allow me to round down the lowest digit, say 5. For example if the value in A1= 1297.19 then the value in A2 should display 1295.00 also if the value in A1=632.67 then I would want to round down to 630.00. Can anyone help? Thanks |
#3
|
|||
|
|||
=int(A1/5)*5
K.S.Warrier "Jerry W. Lewis" wrote: =5*ROUNDDOWN(A1/5,0) Jerry Sam wrote: I am trying to write a formula that will allow me to round down the lowest digit, say 5. For example if the value in A1= 1297.19 then the value in A2 should display 1295.00 also if the value in A1=632.67 then I would want to round down to 630.00. Can anyone help? Thanks |
#4
|
|||
|
|||
Thanks Jerry and KS Warrior. Much appreciated!
Cheers, Sam "Jerry W. Lewis" wrote in message ... =5*ROUNDDOWN(A1/5,0) Jerry Sam wrote: I am trying to write a formula that will allow me to round down the lowest digit, say 5. For example if the value in A1= 1297.19 then the value in A2 should display 1295.00 also if the value in A1=632.67 then I would want to round down to 630.00. Can anyone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie question | New Users to Excel | |||
how to subtract the very next LOWEST number | New Users to Excel | |||
How to find highest, lowest and last cell in row? | Excel Discussion (Misc queries) | |||
Using ROUND formula to calculate tax | Excel Worksheet Functions | |||
how do I get excel 2003 to round up | Excel Worksheet Functions |