Please note: not all of us use the same newsgroup reader. Most of us cannot
rate your answer.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Pranav Vaidya" wrote in message
...
Hi Mac,

Check out the group for today's question...Jim May asked a similar
question

HTH

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"mac" wrote:

Hello,
I have this if statement and when I go to add 2 more if statements I get
an
error. Can you help? Any help will be greatly appreciated. Thank you



=IF(C6="15764",'MA RUGS'!J10,IF(C6="14484",'MA
RUGS'!I10,IF(C6="99922",'MA
RUGS'!L10,IF(C6="39300",'MA RUGS'!I10,IF(C6="49340",'MA
RUGS'!P10,IF(C6="39300",'MA RUGS'!I10,IF(C6="49340",'MA
RUGS'!P10,IF(C6="21604",'MA RUGS'!R10,0))))))))
--
thank you mac