Help needed for NESTED IFs

[ImranBhatti]

Hi to all Experts

in my spreadsheet there are 2 cells
E23 and F23

in C23 I want
1) if E23 and F23 amountts are 0 and 0 then = "Enter some values first"
2) If E23 and F23 are not equal to each other then = "Debits and Credits are not equal"
3) If there is no difference between them then=AmtInWords(E23)&" only" (AmtInWords is a UDF)
I tried many combinations of nested IFs like the bellow one and all produced results for 2 conditions but not all the 3. Any help would be appreciated.

=IF(E23=0,IF(F23=0,"Enter some values first"),IF(E23=F23,"Debits and Credits are not equal",AmtInWords(E23&" only")))

Best Regards
Imran Bhatti

[JohnTopley]

Try

=IF(AND(E23=0,F23=0),"Enter some values first",IF(E23<>F23,"Debits and Credits are not equal",AmtInWords(E23&" only")))

[ImranBhatti]

=IF(AND(E23=0,F23=0),"Enter some values first",IF(E23<>F23,"Debits and Credits are not equal",AmtInWords(E23)&" only"))

Red and bold one was added to your formula and it worked for the third condition

Thanks