include maximum number in fomula

[jv]

I have a formula

=sum(t2*.01*v2) I want the maximum result to be $1500.00

 

[Peo Sjoblom]

=MAX(1500,sum(t2*.01*v2))

 

[jv]

=MAX(1500,sum(t2*.01*v2))

--

Regards,

Peo Sjoblom

 

[BobT]

That's a MIN instead of MAX

-----Original Message-----
=MAX(1500,sum(t2*.01*v2))

--

Regards,

Peo Sjoblom





.

 

[JE McGimpsey]

One way:

=MIN(1500,T2*V2*0.01)

Note that your SUM() is superfluous - it returns the same value as

=t2*0.1*v2

 

[JE McGimpsey]

I'm sure Peo meant "MIN", not "MAX"

 

[jv]

Thank You
JV

That's a MIN instead of MAX