a1=value
b1=rounddown(a1,0)
c1=if(b1=1,1,rounddown(b1/2,0))

-- Carlos

"PastorHankWi" wrote in message
...
I am using the roundown function and everything works fine. However, one
of
my number when rounded down = 1 when 1 is divided in 1/2 (which I have to
do)
the rounddown function takes it to a zero when instead I need it to stay
at
1. If there any to test for a greater than or less than value in a cell?
or
how would ya'll suggest I handle this situation.

Thank you
Hank
PS, I'm a real excel newbie....