View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wilma2299 wilma2299 is offline
external usenet poster
 
Posts: 10
Default Nested If Exceeding 7 Calculations

I'm trying to have a calculation executed, but it has more than 8
arguements. What I need is the following, given a certain quota (I'll
have 6 different quotas to be looked up), find that range and then
execute the calculation. I have 13 different ranges and 13 different
calculations corresponding. I read that I can use a lookup, but I
would rather write a macro, but I have no idea where to start. Thanks!