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.

try:

=CEILING(E14*1.07,0.05)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jean K" <Jean wrote in message
...
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.

Use the Ceiling formula:
=CEILING(A1,0.05)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jean K" wrote:

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.