View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dj dj is offline
external usenet poster
 
Posts: 92
Default More if then logic

Here's another one for ya--

I'm creating a calculator that returns a value based on rankings. Values 1-6
should return X value, values 7-12 return Y value, values 13-22 should return
Z value.
X, Y and Z represent 100% of max, 50% of max and 0% of max respectively. Any
ideas?