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.

Between Formula???
 

Maybe

=INT((MONTH(A2)-1)/3)+1

Mike

"mcp201" wrote:

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.

Between Formula???
 

maybe

=1+int(a2/3)

"mcp201" wrote:

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.

Between Formula???
 

Scratch that.

=ROUNDUP(A2/3,0)

"Duke Carey" wrote:

maybe

=1+int(a2/3)

"mcp201" wrote:

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.