DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

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

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

Hi,

Maybe something like:

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

Hope this helps!
Jean-Guy

"Peter" wrote:

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

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

pinmaster wrote...
Maybe something like:

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

If so, why not

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

?

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

Hi,

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

"pinmaster" wrote:

Hi,

Maybe something like:

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

Hope this helps!
Jean-Guy

"Peter" wrote:

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

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

Hi,

Try:

=MIN(2000,B4*0.3)


HTH
Jean-Guy

"Peter" wrote:

Hi,

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

"pinmaster" wrote:

Hi,

Maybe something like:

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

Hope this helps!
Jean-Guy

"Peter" wrote:

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

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

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


"Harlan Grove" wrote:

pinmaster wrote...
Maybe something like:

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

If so, why not

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

?

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

Thanks guys the =MIN(2000,B4*0.3)
works great. I didn't try the other. It's great to know help is out there
I might have to call on you guys again. I really appreceate the help.

Peter

"pinmaster" wrote:

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


"Harlan Grove" wrote:

pinmaster wrote...
Maybe something like:

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

If so, why not

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

?

DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
 

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

It is, but I beat you to it.