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

formulas

ResolvedVersion 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:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.