I'm getting an error that says "the specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format".

Is there any way around this? I need the entire formula I'm entering into the cell.

This is my formula that I need to entering into the cell.


=IF(AF2="30 Days",(EOMONTH(AE2,1)+20),(IF(AF2="45 Days",(EOMONTH(AE2,1)+30),(IF(AF2="60 Days",(EOMONTH(AE2,2)+20),(IF(AF2="90 Days",(EOMONTH(AE2,3)+20),(IF(AF2="Advance",(AE22+0),(IF(AF2="Net 140Days",(AE2+14),(IF(AF="Net 30 Days",(AE2+30),(IF(AF2="Net 45 Days",(AE2+45),(IF(AF2="Net 60 Days",(AE2+60),(IF(AF2="Net 90 Days",(AE2+90),(IF(AF="COD",(AE2+0),(IF(AF2="COD-E",(AE2+0),0))))))))))))))))))))))

Thanks.