help create a formula using the IF command with AND

  • Thread starter Thread starter joe54345
  • Start date Start date
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?
 
I'm sorry I should clarify the "if not", if A2 is not greater than A1.
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help creating a formula using IF and AND 8
IF _ AND _ OR 3
Like SUMIFS, but for multiplication?? 3
Total formula 1
Copy a formula using Vlookup 2
multiple if/then formulas 1
Formulas 2
Mandatory and optional formula 5

Back
Top