Forum Discussion
Vs Last Week Sales Formula
Hi all, I am creating a sales report for my works stores, however i am stuck on a VS last week formaula. I can do a vs the whole of the week previous e.g £10,000 last week and £5,000 this week = ...
Hi Stevenfeasey ,
I tried a solution with some nested IFs. It is probably not the best way to solve it, but I think that it can help with your case. I'm sending you a file simulating it on Sheet2 (there is also a sheet simulating the previous week).
Let me know if it works for you, or if you have any question or need additional help.
rzanetithanks for this, although i am getting a FALSE error when trying to recreate this. Id i send a copy of the file would this be easier for you to have a look at?
Thank you
Stevenfeasey yes. Please send it.