Thread: include maximum number in fomula
View Single Post
  #4   Report Post  
BobT
 
Posts: n/a
Default
That's a MIN instead of MAX

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

--

Regards,

Peo Sjoblom


"jv" wrote in message
...
I have a formula

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


.

Reply With QuoteReply With Quote