Rayne
asked on
Excel day by day
I want to compare changes in metric value by day. I have a formula but is there a better formula – like the formula that handles the situation of the red cell – where there is no previous date. . What should I do? Please help me with rewriting this formula that a better one for this type of date by date comparison
Thanks
see attched for the red cell...
day-by-day-formula.xlsx
Thanks
see attched for the red cell...
day-by-day-formula.xlsx
Hi Rayne,
Questions:
Q1. What Change value would you like to show in the red cell? 0%?
Q2. Does the formula also have to be able to cater for Metric Values = 0, which would currently give a #DIV/0 error in the Change field?
Q3. If so, what value should it put in the Change field?
Q4. What other things would you like the formula to be able to cater for, and what Change values would you like to show in those cases?
Questions:
Q1. What Change value would you like to show in the red cell? 0%?
Q2. Does the formula also have to be able to cater for Metric Values = 0, which would currently give a #DIV/0 error in the Change field?
Q3. If so, what value should it put in the Change field?
Q4. What other things would you like the formula to be able to cater for, and what Change values would you like to show in those cases?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
ASKER