Multiple embedded IF statements with VLOOKUPs not working

[shawnrpg]

I am trying to alter an existing formula that contains 10 IF statements with a couple VLOOKUPs. The formula currently works but I need to change it to do something slightly different, with significantly fewer IF statements.
The revised formula is:
=IF('Item Information'!$C$3="AIP SCRAP","Tooling has been scrapped! Can't Quote.",IF(M12<730,”AS9102 within 2 years, Layout not required”,IF('Item Information'!$C$10="Aluminum Hand Forgings",VLOOKUP('Item Information'!$C$10,'AS9102 Layout Charges'!$M$11:$N$28,2,FALSE),VLOOKUP('Item Information'!$C$5,'AS9102 Layout Charges'!M11:N28,2,FALSE)))

However, when I press Enter, I get a message box that reads 'There's a problem with this formula. Not trying to type a formula?... and wants me to either put an apostrophe at the beginning or correct it.
The only thing I did was replace 8 of the original IF statements with 1. The statement that I want to add is IF(M12<730,”AS9102 within 2 years, Layout not required”.
If I leave this portion out of the formula, the formula works just fine.

I tried the IF(M12<730,[value if true[,[value if false]) formula in its own cell and it calculates correctly.

I tried placing the IF(M12<730,”AS9102 within 2 years, Layout not required” portion in other locations in the formula but it still doesn't work.

Not sure why this specific IF statement isn't working in the formula.

Thanks for reading and any help you can offer,
Shawn

 

[Kerryx]

Try replacing the "" around ”AS9102 within 2 years, Layout not required” , the ones in the formula look like italics

 

[shawnrpg]

I deleted the quotation marks and re-entered them and that fixed the problem; thanks. Something to do with the font of them (IDK)?