IF formula with multiple conditions

[emmamarycole]

Hi there! I’m trying to figure out a formula that will return either “Match”, “Underpaid”, “Overpaid”. If the 2 values (B16 for amt paid and B34 for amt owed) are within 10.0 of each other, I want it to output “close enough”. Currently, I have it so only when B16=B34 it returns “Match”. Is there a formula to add this last output to the cell?

Here is the formula I have currently:
=IF(B16=B34, “Match”, IF(B34>B16, “Underpaid”, IF(B34<B16, “Overpaid”)))

 

[Joe4]

Welcome to the Board!

Try:

=IF(B16=B34,"Match",IF(ABS(B16-B34)<10,"Close Enough",IF(B34>B16,"Underpaid",IF(B34<B16,"Overpaid"))))

 

[awoohaw]

@Joe4's formula may possible work with out the last IF, since B34<B16 is the only alternative after the first 3 tests, it need not be explicit.

=IF(B16=B34,"Match",IF(ABS(B16-B34)<10,"Close Enough",IF(B34>B16,"Underpaid","Overpaid")))