Thread
:
include maximum number in fomula
View Single Post
#
7
JE McGimpsey
Posts: n/a
One way:
=MIN(1500,T2*V2*0.01)
Note that your SUM() is superfluous - it returns the same value as
=t2*0.1*v2
In article ,
"jv" wrote:
=sum(t2*.01*v2) I want the maximum result to be $1500.00
Reply With Quote