How to write the formula of a few arithmetic operations in Excel?


Help someone versed in Excel, you need to write the following formula.

The amount of cells L2 + M2 divide by 2 result divide into cell J2, then multiply the resulting 100 (i.e. percent).

Or better yet, teach how to solve such problems, where to look, how to Google, etc.

Thank you!
September 26th 19 at 06:56
5 answers
September 26th 19 at 06:58
It is strange that both meets did mistakes :)
Here's Your formula
However, do not suggest to translate into a percentage, Express fractions and to percent:
Right-click on the cell > Format cells... > Number > number formats: Percentage and set the required number of digits after the decimal point. So it will be easier to work with such numbers.
In order to learn enough to read any textbook on akselu for dummies or just the Excel help. for example.
All right. Only considering the order of the calculation formula is written =(L2+M2)/2/J2*100
The operators of division and multiplication have the same precedence, so parentheses are not needed. Don't know what to write about :) - Leilani64 commented on September 26th 19 at 07:01
You me Excel to work not to teach, OK? ) I know about the order of evaluation, parentheses always better to put as a formula in this form is much easier to take apart and fix. This example with a simple addition, when the formulas don't fit in the screen — You completely change your tune, examining other people's calculations without the spaced brackets. - tanner_Wintheis commented on September 26th 19 at 07:04
This is not I teach. The certificate is written. The link I gave.
PS: the Brackets in the formula bar, highlighted that sometimes it is convenient. Also agree. - Leilani64 commented on September 26th 19 at 07:07
September 26th 19 at 07:00
choose the cell where the result will be, begin to write the formula by putting = in a formula field on the simple action of using brackets and operators (you can use a mouse to select the cells)

+ have f1 help(in the formula line) and the formula Builder icon in the beginning

I write from memory eksele at hand
September 26th 19 at 07:02
Can you recommend a book
John Walkenbach / John Walkenbach - Microsoft Excel Bible user
September 26th 19 at 07:04

Since in different languages the order may be different, it is better to actively use brackets.

PS I do Not understand what the difficulty here and what is there to Google
September 26th 19 at 07:06
Drive in Google
excel training manual

And read University manuals - solve the task.

Find more questions by tags Excel