1 of 1 people found this helpful
This formula brings same result for both Week1 and Week2.
Need to see actual data structure to understand what is the expected result.
If [Week]='Week 1' Then ([Estimate]*[Projections for New Release])
ELSEIF [Week] = 'Week 2' Then [Estimate] * [Projections for New Release]
Could you share the packaged workbook or excel at least for us to investigate more?
Thanks for your help!
Attached is the work book for your reference. Please let me know if my projected amount calculation is wrong.
The tab i am working on is projection old.
One more request - There is a input parameter to update estimates by users if they do not like the generated one. This is happening across all countries and I am looking for something where user can input for a specific country and the rest they use from generated calculations.
Could you attach excel as well to understand the expected results?
Still don't understand what is the problem.