View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bastien86 bastien86 is offline
external usenet poster
 
Posts: 6
Default Something is wrong with this IF statment

if(AS31100,73,if(as31000,77,if(as3900,82,if(as3 800,82,if(as3700,84,if(as3600,77,if(as3500,80, if(as3400,85.1,if(as3300,83.4,if(as3200,89.8,if (as3100,103,if(as30,103,0))))))))))))

Does Office cutout after too many nested if? when i click ok on the error it
higlights my 6th last if. If i delete all ifs after and make the 6th last
the last if, it works fine... it also doesn't highlight my as3 reference
after the 6th last if...