View Single Post
  #7   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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