View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcp201 mcp201 is offline
external usenet poster
 
Posts: 12
Default Between Formula???

I wanted to know if there is a between formula. I have a set of data which is
sorted by division, fiscal month, sales, etc. I wanted to insert a formula
which displays quarter numbers if the fiscal month falls within that
criteria.

Example: Fiscal Period Month=7
If(A2 is <=3, display 1
If(A2 is <=6 display 2,

Thanks in advance.