IF value

C

Christine Lombardo

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
 
B

Bob Phillips

How about

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

--

HTH

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

pdberger

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
 
C

Christine Lombardo

Thank you. That worked.

Bob Phillips said:
How about

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top