Hi everyone!
Please see attached a copy of one of the sheets i'm working on.
As you can see im tracking orders for clients however when the base is 0 and they order any value bigger than 0 the following week, excel wont display the percentage increase?
Please can any help solve this?
Thank you in advance!
Hi,
it is displaying something. That something is the "#N/A" error.
You should try this formula instead in E8:
Formula:
Please Login or Register to view this content.
Cheers!
John.
"I excel at jumping to conclusions"
John, thank you so much! works like a treat!
But an increase from 1 to 3 is a 200% increase but from 0 to 3 is a 100% increase (according to the solution given), are you sure you wish to populate with 1 (100%) in the case of the error?
You also have 27th - 3rd as a week it should be the 2nd for January
Last edited by davsth; 01-13-2020 at 07:45 AM.
Hi Davsth,
I have amended to read
This way returning the correct percentage.
Please Login or Register to view this content.
Also thanks for the heads up about the date!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks