formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · 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...

Maria_excel formula.xls

Wed 15 Jun 2011: Automatically marked as resolved.


 

Excel tip:

Closing Multiple Open Worksheets At Once

When 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.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.09 secs.