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

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