View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoeAPM JoeAPM is offline
external usenet poster
 
Posts: 1
Default How do I set up a multiple condition formula?

I have 12 different conditions where I need to assign a number:
If E6 < 36.9, then the number is 0
If E6 =37 and <=37.49 then number is 0.25
If E6 =37.5 and <=37.99 then number is 0.50
E6 =38 and <= 38.49 then number is .75

and so on....

A friend told me that Excel will not let you use more than 7 conditions. Is
this true?

If someone could send me the formula to set up these conditions I would be
greatly appreciative as I have worn out the help tool!

Thanks!

Joe