Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
|
|
|
The UK's most regular 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. |
Formulas
Resolved · High Priority · Version 2007
Reply Mon 6 Jun 2011, 11:02Delegate Maria said...
Maria has attended:
Access Advanced course
Excel Advanced course
Powerpoint Intermediate Advanced course
Excel VBA Intro Intermediate 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.
For upcoming training course dates see: Pricing & availability
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
Reply Mon 6 Jun 2011, 13:00Delegate Maria said...
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
I await your response.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Reply Tue 7 Jun 2011, 08:48Delegate Maria said...
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...
Maria_excel formula.xlsWed 15 Jun 2011: Automatically marked as resolved.
|