help create a formula using the IF command with AND
 

I need to create a formula for below:

IF A2 is greater than A1 AND A4A3 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?

help create a formula using the IF command with AND
 

I'm sorry I should clarify the "if not", if A2 is not greater than A1.

help create a formula using the IF command with AND
 

=if(and(a2a1,a4a3),a4*.04,a4*.03)

or
=a4*(if(and(a2a1,a4a3),.04,.03))

or
=a4*(.03+.01*(and(a2a1,a4a3)))

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




wrote:

I need to create a formula for below:

IF A2 is greater than A1 AND A4A3 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?

--

Dave Peterson