Forum Discussion
dclaudio
3 years agoFrequent Visitor
Need help with a very specific If/Then formula
I am trying to get an estimated budget number each month. Here is what the relevant data looks like:
| Week 1 (Days 1-7) | Week 2 (Days 8-14) | Week 3 (days 15-21) | Week 4 (Days 22-28) | Week 5 (Days 29-31) | |
| 2023 Actuals | 100 | - | - | - | - |
| 2023 Esitmate | 100 | ||||
| 2022 Actuals | 200 | 190 | 202 | 250 | 198 |
What I want is to calculate the "2023 Estimate" using the formula [(Month to date actuals/same period last year actuals)*same period last year actuals] ONLY if the current week is not complete. When I have 2023 actuals, I would like that value to appear in the 2023 estimate cell for that week. Im thinking something like (for week 2) if 'pst'(settlementdate) days < 15, then use the above formula. ELSE it shoudl = 2023 actuals for the same period. Help!
1 Reply
- lbendlin
Super User
Read about COALESCE