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
|