If I have 1 job open and one job
Thank you,
Original Text of Post (reinstated by mod):
If I have 1 job open and one job closed and they recieve 2 floor inspections. Shouldnt it be 50% completion?
But when I divide 1/1 and change to percentage it's 100% completion when it should say 50%. How would I do this. Sorry i'm sure this is simple but I can't figure it out.
Any help would be great.
Last edited by AliGW; 08-19-2018 at 02:44 AM.
Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
- Responding to a request to change your thread title by doing so is mandatory.
To change a title go to your first post, click EDIT then Go Advanced and change your title.
No help to be offered, please, until the OP complies with this request.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, but your question really doesnt make any sense. Perhaps you hit "POST" before you finished typing?Originally Posted by thursday140
When you fix your title, please also try and explain again what you want.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I've edited the opening post and put back the original text. I have no idea why the OP removed it.
The OP's basic maths is suspect!
1/1=1=100%
1/2=0.5=50%
Excel 2016 (Windows) 32 bit
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
Sheet: Sheet1
Cell I8 has had the precentage formatting applied to it from the drop-down menu on the Home ribbon.
Last edited by AliGW; 08-19-2018 at 02:48 AM.
Hi,
Excel 2016 (Windows) 64 bit
Jobs Assigned Jobs Open Jobs Closed Percent Completed Percent Not Completed
Sheet: Sheet40
Excel 2016 (Windows) 64 bit
Sheet: Sheet40
What if I wanted to include jobs assigned and jobs closed, how would you enter this in Excel? For other words in D2 it will now become 75% instead of 50%.
Last edited by AliGW; 08-11-2019 at 12:37 AM. Reason: Please don't quote unnecessarily!
Try: SUM(A2,C2)/SUM(A2:C2)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
That's quite a delay in replying lol?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks