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)

=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