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]

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

Try this -

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

 

[6StringJazzer]

You just gave one specific example. What is the rounding rule you want to apply? Round to the nearest 50? Round up to the nearest multiple of 50? Round up to the nearest multiple of 25?

 

[rlv01]

That's not normally how rounding works. You can round up 35.67 to 35.7 or 36, but you don't normally "round up" to a completely different number. Perhaps you can explain a bit more?

 

[VinceF]

You just gave one specific example. What is the rounding rule you want to apply? Round to the nearest 50? Round up to the nearest multiple of 50? Round up to the nearest multiple of 25?

Yes, I'd like for it to round up to the nearest 50

 

[SanjayGMusafir]

but you don't normally "round up" to a completely different number

We can using Ceiling Function - see thread #2 above

 

[SanjayGMusafir]

Yes, I'd like for it to round up to the nearest 50

Check thread #2 I gave formula -

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

 

[VinceF]

That's not normally how rounding works. You can round up 35.67 to 35.7 or 36, but you don't normally "round up" to a completely different number. Perhaps you can explain a bit more?

I'm looking for the result of the formula to round it up to the next 50. For example, if the formula resulted in 238, I'd like it to round up to 250.
Hope this helps

 

[VinceF]

Try this -

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

Thanks Sanjay but that didn't work as needed.

 

[SanjayGMusafir]

Thanks Sanjay but that didn't work as needed.

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)