Hi,
I have a formula that exceeds the nesting limit on excel. I there any way I can re-write this formula to shorten the nesting amount? I am nested to 84 currently and limit is 64 I believe. Here is a partial sample of what the formula looks like.
=IF('Start Page'!$J20=Costs!$BC$1,Costs!$BB$1,IF('Start Page'!$J20=Costs!$BC$2,Costs!$BB$2,
IF('Start Page'!$J20=Costs!$BC$3,Costs!$BB$3,IF('Start Page'!$J20=Costs!$BC$4,Costs!$BB$4,
IF('Start Page'!$J20=Costs!$BC$5,Costs!$BB$5,IF('Start Page'!$J20=Costs!$BC$6,Costs!$BB$6,
""))))))))))))))))))))))))))))) etc to 84 "nests"
Any help would be appreciated,
Thanks
Bookmarks