Between Formula???

  • Thread starter Thread starter mcp201
  • Start date Start date
M

mcp201

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fiscal Month Formula 3
dynamic table 3
dynamic table 1
Date formula: return Quarter and Fiscal Year of a date 7
Count the Number of Weekdays by Month 3
Still in need of help 3
IF OR Formula 1
Calculations for Quota by month 1

Back
Top