Hi Kurt.

04-Apr-04 05:28:20, Kurt Kuzba wrote to All


 KK> From: "Kurt Kuzba" 

 KK>  I noted that Excel has a rounded step-up function a bit earlier,
 KK>  and wondered briefly how they accomplished it, and consigned it
 KK>  to the depths of unconsciousness thereafter.  When the question
 KK>  came up, an answer just popped up from out of the soup.  Neat.
 KK>  There is no problem so complex that a nap can't help.  

I remember the discussion... ISTR asking for clarification on the numbers
involved.

here's another way to do the same thing but using floats only so you can use
bigger numbers, you can even make step equal to 0.5 :)

#include 
float stepup_if_above( float num, float step)
{
    float rounded = floor(num/step)*step;
    return rounded + ( (rounded==num) ? 0 : step );
}

(don't try it with fractional steps that don't have a power of two as the
divisor as rounding errors will throw the whole-number terms off-course.)

 -=> Bye <=-

---