Trouble with an IF formula

[chickenlicken]

Hello,

I am trying to create a formula that performs different calculations on C10 depending on the answers of Y or N in cells C15 and C16.

It works to a point, but the second nested function, isn't working.
What am I doing wrong?

Thanks!

=IF(AND(C15="Y",C16="Y"),"NOT POSSIBLE",IF(AND(C15="Y",C16="N",),C10*C24,IF(AND(C16="Y",C15="N"),C10*C25,C10)))

[judgeh59]

have you tried using the Evaluate Formula technique?

If you haven't. here is how

click on the cell
click on the Formula Ribbon
in the Formula Auditing section there is an Evaluate Formula button
Click it
notice an Underline and click evaluate.

this will "evaluate" each underline just like XL would during execution. this will allow you to see if the variable are doing what you think/want...

HTH

[chickenlicken]

Thank you! I used that and it helped me notice the extra comma within the parentheses that was causing the issue. I didn't know about that tool, thank you very much.

[judgeh59]

no problem glad I could and thanks for the Rep point....please remember to set the thread to Solved...