Bob meant that you can split the formula up into smaller chunks into
several cells, and then combine them. See my post for an alternative
approach.

Pete

On Oct 3, 4:57 pm, mac wrote:
Hi,

Thank you for your help. What does Bob Phillips mean by multiple cells. As
you can tell I am still learning. I just need one more nesting if statement.
Any ideas? Thank you.
--
thank you mac



"Pranav Vaidya" wrote:
sorry..forgot to mention the name
it was named as Editing and moving from 6 if to 7 if
--
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- Hide quoted text -

- Show quoted text -