counting, multiple conditions and results

K

Kathleen

Hi,

I'm working with payperiods, 1-26. Each payperiod will have either a
payment amount due or is marked na. If payperiod 5 is the beginning of the
amounts due then the previous ones will be marked na. Each payperiod column
has formula to figure out if there should be an amount due or an na. What I
need is for the amounts due to have a total of 6 payperiods and the remaining
payperiods to override the columns existing formula and say "end of 12
weeks". Amounts due would be consecutive. I can have only amounts due for 6
payperiods in total.
 

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

Top