help create a formula using the IF command with AND

J

joe54345

I need to create a formula for below:

IF A2 is greater than A1 AND A4>A3 then A4 should be multiplied by .04,
if not then A4 should be multiplied by .03. Can someone turn that into
a formula for me?
 
D

Dave Peterson

=if(and(a2>a1,a4>a3),a4*.04,a4*.03)

or
=a4*(if(and(a2>a1,a4>a3),.04,.03))

or
=a4*(.03+.01*(and(a2>a1,a4>a3)))

They'll all evaluate the same, so you can use the one that is easiest to
understand.
 
Top