Roundup Function

  • Thread starter Thread starter Hilene
  • Start date Start date
H

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
 
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
 
Hi
not quite sure what you mwan with 'numbers after 4'. Ho do you deine if
you have to roundup to 75 or 100?
 
Back
Top