Roundup Function

[Hilene]

HI!
I'm creating a price list that has specific needs. I need the all
numbers after 4 to be rounded up to either 100, 50 or 75. If I have
133 round down to 100, if 140 round up to 150, etc.

Hope to find some answers here!

Thanks,

Hilene

 

[Bernard V Liengme]

This seems to work =ROUND(E1/25,0)*25 except when E1 ends with 38 or 39
So try
=IF(OR(MOD(E1,100)=38,MOD(E1,100)=39),ROUND(E1/25,0)*25-25,ROUND(E1/25,0)*25
)
If E1 can have decimal values (137.85) we may need to replace E1 by INT(E1)
in the MOD functions

Best wishes
Bernard

 

[Frank Kabel]

Hi
not quite sure what you mwan with 'numbers after 4'. Ho do you deine if
you have to roundup to 75 or 100?