defcon_3
04-12-2012, 09:54 PM
Hi guys,
Can you please help me rewriting this formula because it give me error stating "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format" when i try to use it in 97-2003 format. Originally it was used in xlsx format.
=IF(J4>=120000,35,IF(J4>=117750,34,IF(J4>=115500,33,IF(J4>=113250,32,IF(J4>=111000,31,IF(J4>=80000,30,IF(J4>=72000,29,IF(J4>=64000,28,IF(J4>=58000,27,)))))))))
Thanks
Can you please help me rewriting this formula because it give me error stating "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format" when i try to use it in 97-2003 format. Originally it was used in xlsx format.
=IF(J4>=120000,35,IF(J4>=117750,34,IF(J4>=115500,33,IF(J4>=113250,32,IF(J4>=111000,31,IF(J4>=80000,30,IF(J4>=72000,29,IF(J4>=64000,28,IF(J4>=58000,27,)))))))))
Thanks