LinkBack URL
About LinkBacks
Hi there
I am trying to have a running percentage calculation however the input data is text not numbers. Where N=-7 and Y=+7. This is for a 7 day week. Example given.
Hi there
I am trying to have a running percentage calculation however the input data is text not numbers. Where N=-7 and Y=+7. This is for a 7 day week. Example given.
I do not see any expected outcomes in the attached workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I haven't started yet as I am unsure as to where to start. I have however figured out theat N must equal 0 or the ercentage wont calculate correctly.Originally Posted by AliGW
What I'm trying to do is when I enter Y or N there is a percntage calculated at the end of the week.
You said you had given an example: I do not see any example outcome. Give us an idea of the outcomes you would expect from some lines of data in your workbook (manually calculated).
Perhaps this will work for you.
Enter this formula in Q4 and fill down.
Formula:
Please Login or Register to view this content.
Enter this formula in R4 and fill down.
Formula:Please Login or Register to view this content.
Sorry, error in this. Will get back.
Last edited by newdoverman; 11-27-2016 at 12:39 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
This will work in Excel versions 2007 and later. Sorry, don't have 2003 so can't test solutions for that version.
Enter in Q4 and fill down
Formula:Please Login or Register to view this content.
Enter in R4 and fill down
Formula:Please Login or Register to view this content.
This might work for Excel 2003
Enter in Q4 and fill down
Formula:Please Login or Register to view this content.
Enter in R4 and fill down
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks