rounding question
I am currently on office 2003, but we are upgrading to 2007 in a few weeks.
Question:
I need to take a number, multiply by 1.07 (107%), then take the result and
round up to the nearest 5 or 0.
For example, if I had (.49*1.07) = .5243---I would need the formula to
return .55.
Conversely, I would need (.55*1.07) = .5885 --- I would need the formula to
return .60.
Thank you.
|