rounding
Posted by celeste on October 05, 2001 7:45 AM
i have a column (BY)that has a value that is a percentage. What i want to do, is create a formula in a new column that says if the value in BY is like 5.3 or 5.1 (basically <.49) to round down to 5, and if the value is like 5.8 or 5.7 (basically >.50)then to round down to 5.5, i have all types of values in this column, so i need a formula that only affects the numbers after the decimal point and not the whole number.
TIA!!
Posted by Barrie Davidson on October 05, 2001 7:55 AM
Celeste, try
=FLOOR(A1,0.5)
Regards,
Barrie
Barrie Davidson
Posted by celest on October 05, 2001 8:14 AM
that is returning a blank cell! the first value that i have is 5.63%. i want to make that 5.5%. the A1 in your formula is BY58 in my spreadsheet. i typed in =FLOOR(BY58,0.05), and it returned a blank cell. any more ideas????
Posted by Barrie Davidson on October 05, 2001 8:26 AM
Change your formula to =FLOOR(BY58,0.005) and format the cell to %.
BarrieBarrie Davidson
