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" wrote in message
...
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" wrote in message
...
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