MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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