J
jv
I have a formula
=sum(t2*.01*v2) I want the maximum result to be $1500.00
=sum(t2*.01*v2) I want the maximum result to be $1500.00
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
Peo Sjoblom
=MAX(1500,sum(t2*.01*v2))
J
jv
Peo Sjoblom said:=MAX(1500,sum(t2*.01*v2))
--
Regards,
Peo Sjoblom
B
BobT
That's a MIN instead of MAX
-----Original Message-----
=MAX(1500,sum(t2*.01*v2))
--
Regards,
Peo Sjoblom
.
J
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
=MIN(1500,T2*V2*0.01)
Note that your SUM() is superfluous - it returns the same value as
=t2*0.1*v2
J
JE McGimpsey
I'm sure Peo meant "MIN", not "MAX"
J