Thread: IF value

I need to create an equation.

If (roundup(AE104*2,-3)>=300000) then =300000 or if
(roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)

Basically:
If y>=x then x, if y<x then y

Christine --

Howz about:

=if(y>=x,x,y)

hth,

Peter

"Christine Lombardo" wrote:

> I need to create an equation.
>
> If (roundup(AE104*2,-3)>=300000) then =300000 or if
> (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
>
> Basically:
> If y>=x then x, if y<x then y

When I do that it always shows y as true when I know that it is not.

"pdberger" wrote:

> Christine --
>
> Howz about:
>
> =if(y>=x,x,y)
>
> hth,
>
> Peter
>
> "Christine Lombardo" wrote:
>
> > I need to create an equation.
> >
> > If (roundup(AE104*2,-3)>=300000) then =300000 or if
> > (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
> >
> > Basically:
> > If y>=x then x, if y<x then y

How about

=MIN(300000,ROUNDUP(AE104*2,-3))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pdberger" <pdberger@discussions.microsoft.com> wrote in message
news:DE7E29CC-F9F2-4ED8-AD66-335E29EE4C5E@microsoft.com...
> Christine --
>
> Howz about:
>
> =if(y>=x,x,y)
>
> hth,
>
> Peter
>
> "Christine Lombardo" wrote:
>
> > I need to create an equation.
> >
> > If (roundup(AE104*2,-3)>=300000) then =300000 or if
> > (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
> >
> > Basically:
> > If y>=x then x, if y<x then y

Christine -- I may not understand what you're trying to accomplish. I
created the following, which seems to work the way I understand you need:

A B C

1 5 4 =IF(A1>=B1,B1,A1)
2 5 5 copied down...
3 5 6

I got the following results: In 'C1' the result was 4, 'C2' was 5, and 'C3'
was 5. Is that not a simplified version of what you wanted?

hth


"Christine Lombardo" wrote:

> When I do that it always shows y as true when I know that it is not.
>
> "pdberger" wrote:
>
> > Christine --
> >
> > Howz about:
> >
> > =if(y>=x,x,y)
> >
> > hth,
> >
> > Peter
> >
> > "Christine Lombardo" wrote:
> >
> > > I need to create an equation.
> > >
> > > If (roundup(AE104*2,-3)>=300000) then =300000 or if
> > > (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
> > >
> > > Basically:
> > > If y>=x then x, if y<x then y

Thank you. That worked.

"Bob Phillips" wrote:

> How about
>
> =MIN(300000,ROUNDUP(AE104*2,-3))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "pdberger" <pdberger@discussions.microsoft.com> wrote in message
> news:DE7E29CC-F9F2-4ED8-AD66-335E29EE4C5E@microsoft.com...
> > Christine --
> >
> > Howz about:
> >
> > =if(y>=x,x,y)
> >
> > hth,
> >
> > Peter
> >
> > "Christine Lombardo" wrote:
> >
> > > I need to create an equation.
> > >
> > > If (roundup(AE104*2,-3)>=300000) then =300000 or if
> > > (roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
> > >
> > > Basically:
> > > If y>=x then x, if y<x then y
>
>
>