Hi,
I am receiving the below message while trying a formula.
"The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format."
Formula is:
=IF(OR(C9=C8,C9=C7),0,IF(B9=1,MAFRAQ!K$68,IF(B9=2,MAFRAQ!L$68,IF(B9=3,MAFRAQ!M$68, IF(B9=4,MAFRAQ!N$68, IF(B9=5,MAFRAQ!O$68, IF(B9=6,MAFRAQ!P$68, IF(B9=7,MAFRAQ!Q$68, IF(B9=8,MAFRAQ!R$68, IF(B9=9,MAFRAQ!S$68, IF(B9=10,MAFRAQ!T$68, IF(B9=11,MAFRAQ!U$68, IF(B9=12,MAFRAQ!V$68, IF(B9=13,MAFRAQ!W$68, IF(B9=14,MAFRAQ!X$68, IF(B9=15,MAFRAQ!Y$68, IF(B9=16,MAFRAQ!Z$68, IF(B9=17,MAFRAQ!AA$68, IF(B9=18,MAFRAQ!AB$68, IF(B9=19,MAFRAQ!AC$68, IF(B9=20,MAFRAQ!AD$68, IF(B9=21,MAFRAQ!AE$68, IF(B9=22,MAFRAQ!AF$68, IF(B9=23,MAFRAQ!AG$68, IF(B9=24,MAFRAQ!AH$68, IF(B9=25,MAFRAQ!AI$68, IF(B9=26,MAFRAQ!AJ$68, IF(B9=27,MAFRAQ!AK$68, IF(B9=28,MAFRAQ!AL$68, IF(B9=29,MAFRAQ!AM$68, IF(B9=30,MAFRAQ!AN$68, IF(B9=31,MAFRAQ!AO$68,0))))))))))))))))))))))))))))))))
Please help.
Regards,
Bookmarks