IF or Lookup
I am trying to tell the cell to display the proper Quarter for the Month typed.
Jan-Mar = Q1
Apr-Jun = Q2
Jul-Sep = Q3
Oct-Dec = Q4
The probelm is IF functions only allow 7 itmes to be added & I would need at
least 8 to properly work. and I tried Lookup & haven't been able to properly
work either.
Any suggestions?
|