Multiple IF statements are giving me a FALSE response instead of the requested BLANK.
I figured that the last of the IF statements that has a "" would give BLANK if none of the conditions are met.
I've tried isolating each IF to see if I'm missing a statement but I don't see it.
Here is my formula:
=IF((LEFT(D5,2))=H2,IF(C5="Yearly",G5,IF(C5="Fixed Monthly",G5/12,"")))
How can I modify this formula so that it does not give me a FALSE and instead gives me a BLANK as requested on the 3rd IF statement.
Thank you.
Aucun commentaire:
Enregistrer un commentaire