How this IF formula works
The amount test returns TRUE and the manager-approval test returns FALSE. AND therefore returns FALSE, and IF selects Reject.
The top row above is the whole formula. Open any argument that holds a calculation of
its own to see the values it used. Excel works out those inner parts first, because the
function around them needs their results. Edit a cell in the grid to see every value
update.
Try your own formula and data
The sample spreadsheet is fully editable. Change the formula or any cell it references.
The intermediate values recalculate in your browser.
Common mistakes with IF
If this formula is not doing what you expect, one of these is usually why.
Why does IF with AND reject when one condition is true?
AND requires every condition to be TRUE. If either the amount test or approval test fails, AND returns FALSE and IF uses its rejection branch.
When should I use OR instead of AND?
Use OR when any one condition is enough. Use AND when all requirements must pass together.
Why does Yes not match my cell?
Text criteria must be quoted and spelled consistently. Hidden spaces can make "Yes " different from "Yes".
Can AND contain more than two conditions?
Yes. Add more comma-separated tests inside AND; it returns TRUE only when every one of them is true.