counting, multiple conditions and results
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. |
counting, multiple conditions and results
I think I did a poor job of explaining. I'll try again and repost. "Kathleen" wrote: 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. |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com