Excel 2007 : Nesting Issue

[wallygator1922]

Can someone kindly help me with the following formula. The formula is working in one workbook but not another. I keep getting a nesting error. Thanks so much.

=IF(OR(A14={1,4,7,10}),1,IF(OR(A14={2,5,8,11}),2,IF(OR(A14={3,6,9,12}),3,IF(OR(A14={13,16,19,22}),4,IF(OR(A14={14,17,20,23}),5,IF(OR(A14={15,18,21,24}),6,IF(OR(A14={25,28,31,34}),7,IF(OR(A14={26,29,32,35}),8,IF(OR(A14={27,30,33,36}),9,0)))))))))

[jeffreybrown]

Are you by any chance changing between 2003 an 2007?

I would look into building a lookup table.

[wallygator1922]

Thanks so much. Yes, I am switching between 03 and 07. I suppose I'll try saving as an 07 file and see if that works. I am unfamiliar with LOOKUP table.

[jeffreybrown]

A lookup table is nothing but two columns, first column holds the lookup value and second column holds what you want to return.

Please Login or Register  to view this content.

[wallygator1922]

Perfect. Thanks so much. Greatly appreciated.

[jeffreybrown]

You are very welcome. Glad it works for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save