R
Rachael F
Thanks Biff. The formula worked a treat.
Best wishes.
Rachael
Best wishes.
Rachael
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
--
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
R
Rachael F
D
David Biddulph
You're welcome. Glad it helped.
T
T. Valko
You're welcome. Thanks for the feedback!
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.
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.