=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