Thread: Nesting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna Donna is offline
external usenet poster
 
Posts: 180
Default Nesting

I need to add another level (if over 600,000 then 900) to this formula and
when I do I get an error that the formula is over the level of nesting
allowed. Got any ideas?

=IF(E13550000,800,IF(E13500000,700,IF(E13450000 ,600,IF(E13400000,500,IF(E13350000,400,IF(E1330 0000,300,IF(E13250000,200,IF(E13200000,100,0)))) ))))