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

I should look where?

On Jun 13, 1:54 pm, "Don Guillett" wrote:
Look in vba help index for select case

--
Don Guillett
SalesAid Software
"wilma2299" wrote in message

oups.com...



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!- Hide quoted text -


- Show quoted text -