3 condition IF formula help needed please

[Alex D]

What I am trying to do, is create a formula for the QA PAYOUT column, where, IF the QA DQ column is Y, the result is $0, if the QA column result is between 86%-89.99%, the result is $100 and if the QA column result is 90% or higher, the result is $200

QA	QA DQ?	QA Payout
84.05%	Y

 

[sprigelz]

Try this

=IF(B2="Y",0,IF(AND(A2>=0.86,A2<=0.8999),100,200))

Format the formula cell as Currency or Accounting

Please note that this formula will show result 200 if QA is less than 86% as well. If you want to show something different in that case, let me know.

 

[Alex D]

Try this

=IF(B2="Y",0,IF(AND(A2>=0.86,A2<=0.8999),100,200))

Format the formula cell as Currency or Accounting

Please note that this formula will show result 200 if QA is less than 86% as well. If you want to show something different in that case, let me know.

Thank you!!! Actually, that formula is perfect...I have tested and QA scores under 86 are coming back with $0, which is what I would like. Thank you again.