Thread: include maximum number in fomula
View Single Post
  #3   Report Post  
jv
 
Posts: n/a
Default


"Peo Sjoblom" wrote:

=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