P
Peter
Ok, Im wanting to have a formula that displays a fixed mumber if the result
from my formuls is = to or > than the results
from my formuls is = to or > than the results
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pinmaster
Hi,
Maybe something like:
=if(SUM(A1:A10)>=100,100,SUM(A1:A100))
Hope this helps!
Jean-Guy
Maybe something like:
=if(SUM(A1:A10)>=100,100,SUM(A1:A100))
Hope this helps!
Jean-Guy
H
Harlan Grove
pinmaster wrote...
If so, why not
=MIN(100,SUM(A1:A10))
?
....Maybe something like:
=if(SUM(A1:A10)>=100,100,SUM(A1:A100))
If so, why not
=MIN(100,SUM(A1:A10))
?
P
pinmaster
Hi,
Try:
=MIN(2000,B4*0.3)
HTH
Jean-Guy
Try:
=MIN(2000,B4*0.3)
HTH
Jean-Guy
Peter said:Hi,
What I'm trying to do is =(B4*0.3) but if this amount is >or=to 2000 then
display 2000
P
pinmaster
Isn't that what I suggested in my second post???
H
Harlan Grove
pinmaster wrote...
It is, but I beat you to it.
Isn't that what I suggested in my second post???
It is, but I beat you to it.