Nested IF Function returns #NAME? Error
Sheeloo,
i have tried it with the extra parenthesis, same error results.
"Sheeloo" wrote:
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?
|