Rounding Question

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....

If you want anything less than one to be one and you never want any zeros,
try IF(ROUNDDOWN(A1,0)=0,1,ROUNDDOWN(A1,0)). If there are legitimate zero
cells, try IF(A1>0,IF(ROUNDDOWN(A1,0)=0,1,ROUNDDOWN(A1,0)),0)

Hope that helps.

Jane

"PastorHankWi" wrote:

> 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....

Fantastic, thank you ma'am, that's exactly what I wanted to do. I program
with VFP and couldn't find anything about IF statements in the Excel Doc.

Thanks again.
H


"Jane" wrote:

> If you want anything less than one to be one and you never want any zeros,
> try IF(ROUNDDOWN(A1,0)=0,1,ROUNDDOWN(A1,0)). If there are legitimate zero
> cells, try IF(A1>0,IF(ROUNDDOWN(A1,0)=0,1,ROUNDDOWN(A1,0)),0)
>
> Hope that helps.
>
> Jane
>
> "PastorHankWi" wrote:
>
> > 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....

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

-- Carlos

"PastorHankWi" <PastorHankWi@discussions.microsoft.com> wrote in message
news:ECA92F12-1331-4A96-BA77-A9A8DB938B19@microsoft.com...
>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....