| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
