Expanding a formula

[Bedford]

I have a formula that works fine; =IF(J9="None","0",IF(J9="Single","1",IF(J9="Double","2"))).
Now I wish to expand exponentially to return up to a "6". From "Double" continuing to "Triple","3" and so on. I've tried repeating the original parts of the formula only to find it returning an error.
My attempt that returns an error looks like; =IF(J9="None","0",IF(J9="Single","1",IF(J9="Double","2",IF(J9=”Triple”,”3”,IF(J9=”Quad”,”4”,IF(J9=”Quin”,”5”,IF(J9=”Sext”,”6”)))))))
However it returns error; #NAME?
Any help with solving this would be appreciated.
Thank you.

 

[etaf]

no, i have trouble going back to my windows 10 machine having been around macs now for a few years

switch it on and its instant available to work
free upgrades on software, never out of date , like my XP, VISTA, WIN7 machines - also had an 8.1 but that was terrible

I used to work in computers when took up floors - and then went out on my own training and fixing ........
changing to a Mac was because they seem to work well, fast , even compared with the high-spec laptops i had in the past
but ..... that often gets into all sorts of discussions .......

 

[Bedford]

no, i have trouble going back to my windows 10 machine having been around macs now for a few years

switch it on and its instant available to work
free upgrades on software, never out of date , like my XP, VISTA, WIN7 machines - also had an 8.1 but that was terrible

I used to work in computers when took up floors - and then went out on my own training and fixing ........
changing to a Mac was because they seem to work well, fast , even compared with the high-spec laptops i had in the past
but ..... that often gets into all sorts of discussions .......

Yes, the mac vs windows discussion, highly contentious. I only wish the mac was a little less expensive, I think I paid CAD$4200 for this 15" macbook pro in 2015, now 7 years old, still very relevant.