Thread: 4 IFs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 4 IFs

How can 4 ifs give me one of 3 numbers in the following situations:

If between 1200-2000, = 3
If between 2001-2400, = 1
If between 0001-0400, = 1
If between 0401-1199, = 2

Thanks,

Steve