Need Help With Rounup Formula

[VinceF]

Appreciate any assistance..

=SUM(C13-C13*$E$4)/$B$9*5

C13 is 249
E4 is 41%
B9 is 21

The result of the formula is 35 but I'd like it to roundup to 50

Thanks in advance..!
VinceF
Office 2016

 

[SanjayGMusafir]

Thanks Sanjay but that didn't work as needed.

The problem could be in this formula

=SUM(C13-C13*$E$4)/$B$9*5

First check what value it is returning

The formula I gave would roundup to nearest 50

 

[VinceF]

Can you share a screenshot or XL2BB to understand the challenge

Check this -

All Records.xlsb
	E	F
5	35	50
Sheet1

Cell Formulas
Range	Formula
F5	F5	=CEILING(E5,50)

I'll have to install XL2BB on this laptop...it may take a bit..thanks

 

[VinceF]

The problem could be in this formula

=SUM(C13-C13*$E$4)/$B$9*5

First check what value it is returning

The formula I gave would roundup to nearest 50

Yes it did round up to 50 but the number that needs to be rounded varies...some results to the formula end up with 235, or 862, etc., etc...the formula will need to round a number to the next 50. 235 would go to 250, 862 would go to 900 etc., etc

 

[SanjayGMusafir]

but the number that needs to be rounded varies...

This is because of the wrong formula you have put. Check below -

Check this -

All Records.xlsb
	A	B	C
2	249
3	41%
4	21
5
6	Your formula	1.40	50
7	Should be	34.98	50
Sheet1

Cell Formulas
Range	Formula
B6	B6	=SUM(A2-A2*A3)/A4/5
C6:C7	C6	=CEILING(B6,50)
B7	B7	=(A2-(A2*A3))/(A4/5)

 

[VinceF]

This is because of the wrong formula you have put. Check below -

Check this -

All Records.xlsb
	A	B	C
2	249
3	41%
4	21
5
6	Your formula	1.40	50
7	Should be	34.98	50
Sheet1

Cell Formulas
Range	Formula
B6	B6	=SUM(A2-A2*A3)/A4/5
C6:C7	C6	=CEILING(B6,50)
B7	B7	=(A2-(A2*A3))/(A4/5)

Thank you Sanjay...it's working fine now...this post is "solved"

VinceF

 

[SanjayGMusafir]

Thank you Sanjay...it's working fine now...this post is "solved"

VinceF

Glad to help you