I need help with my =if statement. I been playing around and can't seem to get it to work. 2015 either works and 2014 says #value. or 2015 says #value and 2014 works. I'm thinking it might be the parenthesis but playing with it either doesn't work or ends up exactly like the formula below Here is my formula:
=IF(OR(ISBLANK(P2),ISBLANK(Q2),U2<>""),"",IF(Y2=2015,IF((AO2="Gain"),(ROUND(IF(AU2="Yes",((AT2-'Calculator 15'!$C$34)'Calculator 15'!C36),0),2)),0),IF((AO2="Gain"),(ROUND(IF(AU2="Yes",((AT2-'Calculator 14'!$C$34)'Calculator 14'!C36),0),2)),0)))
Aucun commentaire:
Enregistrer un commentaire