Thread: Function
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

=min(12,e3*3+d3*2)

or

=if((e3*3+d3*2)12,12,(e3*3+d3*2))

NewLearner wrote:

I am trying to do a if, then statement

If (E3*3+D3*2) is greater than 12 then enter 12 otherwise give me the total
of the sum of (E3*3+D3*2)


--

Dave Peterson