"IF" Excel Help (please!)

[ssmacc]

Hello,

Can anyone tell me why the below isn't working?

=IF(CI5="yes",DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+210),IF(CI5 = “no”,DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+126),IF(CI5=”n/a”,DATE(YEAR(C5),MONTH(C5),DAY(C5)+126),””)))

Any help appreciated...

 

[ssmacc]

Hello,

Thanks for the response, I'd actually found the very bizarre problem. A friend had somehow quotation marks that tripped excel! The top one works, the bottom one doesn't (took me ages to spot it!)

IF(CI5="yes",DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+210),IF(CI5="no",DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+126),IF(CI5="n/a",DATE(YEAR(C5),MONTH(C5),DAY(C5)+126),"1")))

IF(CI5="yes",DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+210),IF(CI5=“no”,DATE(YEAR(CG5),MONTH(CG5),DAY(CG5)+126),IF(CI5=”n/a”,DATE(YEAR(C5),MONTH(C5),DAY(C5)+126),”1”)))

edit since found out the mistake was editing the formula in word! Not my mistake