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.