98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · High Priority · Version 2007
Maria has attended:
Access Advanced course
Excel Advanced course
PowerPoint Intermediate Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - Formulas & Functions course
Formulas
Hi, I am trying to create the following for a report:
I have a row of 16 cells, each cell needs to represent 6.25%. So each time any of these cells are marked with a '1', it will deduct 6.6% from a total score of 100%
Please can you help?
Thank you.
RE: Formulas
Hello Maria,
Hope you enjoyed your Microsoft courses with Best STL.
Thank you for your question regarding Excel formulas.
Please send me a sample data file with a clear explanation of what you are trying to achieve. I will then create the formulas which will carry out your request.
I look forward to hearing from you.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Formulas
Hi Rodney,
Thank you for your reply. I did enjoy my course.
Unfortunately I am not sure how to send attachments, as there is no option to do so. Although I spotted an error in my question, so my apologies.
I have a column labelled '% Complete' and a row of 16 cells, I would like each cell to represent 6.6%. (because 100/16 = 6.6) When any of these 16 cells have a '1' inputted into it, I will need 6.6% deducted from a total score of 100% (% complete)
This report is for quality assurance, every time i find an error in a record this will knock points off the original score of 100.
I hope this is much clearer.
Many thanks
Maria
RE: Formulas
Hello Maria,
Thanks for coming back to me. You can email your file to me as an attachment to:
rl@stl-training.co.uk
I await your response.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Formulas
Thank you Rodney.
The sample file has now been sent.
Kindest regards
Maria
RE: Formulas
Hello Maria,
Many thanks for the file which was most helpful. I have created some formulas into this file which produce the results you are looking for. Please examine them and let me know if this forum post has been answered.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
Wed 15 Jun 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |