Remove all the closing parenths ")" within the formula and add them to the
very end of the formula:

=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","")))))

--
Biff
Microsoft Excel MVP


"bw" wrote in message
...
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?