Sum and round up query

[Sandiabella]

Hello - I am trying to round up a value to the nearest 50 (with no decimal places), the value is a sum lookup from a different tab, it looks like this but doesn't work;

=ROUNDUP(SUM('2 Granted Patent Renewals'!P8+'2 Granted Patent Renewals'!P24+'2 Granted Patent Renewals'!P40+'2 Granted Patent Renewals'!P56),0)

I have tried ROUND too but neither work, can someone help?

Thanks!

 

[etaf]

try
=CEILING(SUM(SUM('2 Granted Patent Renewals'!P8+'2 Granted Patent Renewals'!P24+'2 Granted Patent Renewals'!P40+'2 Granted Patent Renewals'!P56),50)

that will ROUNDUP
so if the result of the sum is say 10 - it will still roundup to 50 and not down to 0

Book4
	A	B	C
1
2	1		50
3	2
4	20
5	1.222
Sheet1

Cell Formulas
Range	Formula
C2	C2	=CEILING(SUM(A2:A9),50)

 

[Sandiabella]

try
=CEILING(SUM(SUM('2 Granted Patent Renewals'!P8+'2 Granted Patent Renewals'!P24+'2 Granted Patent Renewals'!P40+'2 Granted Patent Renewals'!P56),50)

that will ROUNDUP
so if the result of the sum is say 10 - it will still roundup to 50 and not down to 0

Book4
	A	B	C
1
2	1		50
3	2
4	20
5	1.222
Sheet1

Cell Formulas
Range	Formula
C2	C2	=CEILING(SUM(A2:A9),50)

You're a star - that's worked, thank you so much!

 

[etaf]

you are welcome

i think ceiling.math has replaced ceiling, so ceiling is there for backward compatibility , not sure
=CEILING.MATH(SUM(A2:A9),50)

not sure what difference it makes (ceiling.math handles negative numbers)

Book6
	A	B	C	D
1
2	1		50	50
3	2
4	20
5	1.222
Sheet1

Cell Formulas
Range	Formula
C2	C2	=CEILING(SUM(A2:A9),50)
D2	D2	=CEILING.MATH(SUM(A2:A9),50)