Calculating a percentage and then rounding it up.

[TheRadioBoy]

Hello, newbie here - nice to be a part of the forum.

Could someone please help?

I am trying to calculate two fields together (to get a price) and then wish to add on 20% to that and round it to the nearest fifty, for instance £837.60 to £850.00, is this possible please?

I seem to remember using the CEILING funtion for this perviously.

Any help you can give would be greatly appreciated!

Regards,
Rob.

 

[Gerald Higgins]

Hi, welcome to the board.

Let's assume your "two fields" are in A1 and A2, and the 20% is in A3, entered as 20.

If you ALWAYS want to ROUND UP (and never round down, for example £800.01 also becomes £850.00) then CEILING can do this, as follows

=CEILING((A1*A2)*(1+A3/100),50)


You can also make the 50 a variable, like this

=CEILING((A1*A2)*(1+A3/100),A4)

 

[TheRadioBoy]

BIG thanks for this, that's a huge help and has now allowed me to complete my sheet.

Kind regards,
Rob.