Function

[Guest]

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]

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

or

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