There is one left parenthesis "(" missing after each IF except for the first
one.
Add ( after each IF except the first and then add four ")" at the end...

=IF(('Comparison Chart'!H63="Select One"),"Select One", IF(('Comparison
Chart'!H63="Monthly"),"Monthly", IF(('Comparison Chart'!H63="2.5%
DiscountPaid Quarterly"),"Quarterly",IF(('Comparison Chart'!H63="5.0%
Discount PaidSemiAnnually"),"SemiAnnually",IF(('Comparison Chart'!H63="12.0%
Discount PaidAnnually"),"Annually","")))))

You should simply set up the conditions in one column and result in another
and use VLOOKUP.

"bw" wrote:

Help- i can't figure out why this is not working. the error i am receiving is
centered on the word Monthly, and i don't know why Excel doesn't want me to
use this word. i have confirmed that the cell formating is for Text, not
numbers or something else.
The nesting is 5 formulas, less then the 7 max.

=IF(('Comparison Chart'!H63=€œSelect One€�),€œSelect One€�,IF('Comparison
Chart'!H63=€œMonthly€�),€œMonthly€�, IF('Comparison Chart'!H63=€œ2.5% Discount
Paid Quarterly€�),€œQuarterly€�,IF('Comparison Chart'!H63=€œ5.0% Discount Paid
SemiAnnually€�),€œSemiAnnually€�,IF('Comparison Chart'!H63=€œ12.0% Discount Paid
Annually€�),€œAnnually€�,"")

Basically if you select: Select One, Monthly, 2.5% Discount..., 5.0%
Discount...,12.0% Discount..., on the sheet 'Comparison Chart' cell H63, it
should return the nickname of Select One, Monthly, Quarterly, SemiAnnully,
Annually, or leave it blank. but it just isnt working at all! WHY?
i am at a loss i have checked my quotes, commas, and parenthesis, in
addition to references and spelling. What is it?