Roundup or Ceiling Function to round to a specific number

R

Rachael F

Hello

I would also like a formula to rounddown to the nearest 49p or 99p. I can
only manage to rounddown to 99p.

eg. £12.06 would rounddown to £11.99
£12.49 would stay as £12.49
£12.58 would rounddown to £12.49
£12.99 would stay as £12.99

Many thanks.

Rachael
 
D

David Biddulph

=FLOOR(A1+0.01,0.5)-0.01
--
David Biddulph

Rachael F said:
Hello

I would also like a formula to rounddown to the nearest 49p or 99p. I can
only manage to rounddown to 99p.

eg. £12.06 would rounddown to £11.99
£12.49 would stay as £12.49
£12.58 would rounddown to £12.49
£12.99 would stay as £12.99

Many thanks.

Rachael
Click to expand...
 
A

Angie33

Bob, if you are out there I need your assistance once again. you created
this formula for me to have my numbers end in either a 5 or a 9 and it works
great, can this formula be altered to end in either 49 or 99, depending on
where the numbers fall. Example 419 rounded down to 399, 329 rounded down to
299, 339 rounded up to 349, 359 rounded down to 349 or 369 rounded up to 399.
Of couse the numbers will be larger. Any assistance I can get with this
would be great. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding up or down to nearest whole number 1
MOD and Ceiling formula used to round up and down to 49 and 99 3
roundup function 3
Round formula 1
Roundup Function 5
Rounding to the nearest 25 including negative numbers?? 5
Round up or down by set variable 3
Round up an average 3

Top