Thread: include maximum number in fomula
View Single Post
  #5   Report Post  
jv
 
Posts: n/a
Default
Thank You
JV

"BobT" wrote:

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