why is excel correcting my if statement (if false value) with three quotations?

[bleeet]

excel tells me there is an error with my if statement then changes the false value at the end of the formula with 3 quotations (""") this causes the cells to have the word false when the option isn't picked

here is the statement

=IF(AND(E57="BRANCH PAYS ADDITIONAL FEES:",G54<0),"ADDITIONAL FCT FEES $"&TEXT(G60,"0.00")&" CHARGED TO BRANCH & SWITCH IN PROMO CHARGED FOR FCT FEES & DISCHARGE FEES",IF(E57="branch pays additional fees:","ADDITIONAL FCT FEES $"&TEXT(G60,"0.00")&" CHARGED TO BRANCH",IF(AND(E57="DEBIT ADDITIONAL FEES:",G54<0),"ADDITIONAL FCT FEES $"&TEXT(G60,"0.00")&" DEBITED FROM CLIENTS ACCOUNT & SWITCH IN PROMO CHARGED FOR FCT FEES & DISCHARGE FEES",IF(E57="DEBIT ADDITIONAL FEES:","CLIENTS ACCOUNT DEBITED ADDITIONAL FCT FEES $"&TEXT(G60,"0.00")&",""))))

it then gives me an error and auto corrects the """ at the end of the formula

how can i correct this?

 

[Joe4]

It looks like you have unbalanced double-quote marks in your formula, specifically, just before the last FALSE clause, you have:
&"
So there is a single double-quote apparently with no second double-quote to close it.

 

[bleeet]

ahhh thank you

 

[grizle]

Theres a lone " after the final &. I guess theres a text phrase missing.

Oops! Joe4 already found it.