Excel 2007 : Rounding up a figure when a formula is already present in that cell

Hi, i am new on here and really need help

I have used excel for many years but never knew just how clever it could be! Although i fear i cannot use it properly and am now very stuck and it is probably an easy fix :S

Ok here goes....

I have 2 sheets, both identical, sheet 1 has a price list in euro, sheet 2 is the exact same price list but each cell contains the formula to convert from euro to £'s sheet1!D16*0.82

Now all I want to do is round up the result of this formula to the nearest 50p (eg £5.12 = £5.50, £1.57 = £2.00)

Is this possible? The only way I can manage at the moment is to use another cell and use ceiling =CEILING(D16,0.5) but ideally i want the figure rounding in the original box after the sum has been made.....

Is there any one who can help me? Please? I will be eternally grateful

Many thanks

tired and confused me

Hello
Unless I'm missing something, I think you just need to wrap your Sheet 2 calculation within the Ceiling Function.

=CEILING(Sheet1!D16*0.82,0.5)

DBY

Oh that is great thank you so much! errr just one other thing, I also have some formulas =ROUND(Tabelle1!D118*0.81,2)

How do i use the ceiling thingy in here?

Thanks again, really really appreciate it

Once again you can wrap it inside the Ceiling function.

=CEILING(ROUND(Table1!D18*0.82,2),0.5)

Bear in mind though than 0.5 will stay at 0.5 not move up. e.g. 3.50 will stay at 3.50 not move up to 4.00.

DBY

DBY you are a GENIUS!

Thank you so much!

My superior (who has no idea what so ever how to even open an excel sheet) thinks i am a genius too now!

I fear you may be hearing from me again though lol!

Have a fabulous day, thanks again

x x