DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS

[Guest]

Ok, Im wanting to have a formula that displays a fixed mumber if the result
from my formuls is = to or > than the results

 

[Guest]

Hi,

Maybe something like:

=if(SUM(A1:A10)>=100,100,SUM(A1:A100))

Hope this helps!
Jean-Guy

 

[Harlan Grove]

pinmaster wrote...

Maybe something like:

=if(SUM(A1:A10)>=100,100,SUM(A1:A100))

....

If so, why not

=MIN(100,SUM(A1:A10))

?

 

[Guest]

Hi,

Try:

=MIN(2000,B4*0.3)


HTH
Jean-Guy

Hi,

What I'm trying to do is =(B4*0.3) but if this amount is >or=to 2000 then
display 2000

 

[Guest]

Isn't that what I suggested in my second post???

 

[Harlan Grove]

pinmaster wrote...

Isn't that what I suggested in my second post???

It is, but I beat you to it.