Hello!

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!

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!

asked September 26th 19 at 06:56

5 answers

answered on

Solution

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. office.microsoft.com/ru-ru/novice/FX101820736.aspx for example.

Here's Your formula

`=(((L2+M2)/2)/J2)*100`

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. office.microsoft.com/ru-ru/novice/FX101820736.aspx for example.

answered on 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

`=(((L2+M2)\2)\J2)*100`

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

I write from memory eksele at hand

answered on September 26th 19 at 07:02

Can you recommend a book

John Walkenbach / John Walkenbach - Microsoft Excel Bible user

John Walkenbach / John Walkenbach - Microsoft Excel Bible user

answered on September 26th 19 at 07:04

`=((L2+M2)/J2)*100`

ru.wikipedia.org/wiki/%D0%9F%D1%80%D0%B8%D0%BE%D1%...

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

answered on September 26th 19 at 07:06

Drive in Google

excel training manual

And read University manuals - solve the task.

excel training manual

And read University manuals - solve the task.

Find more questions by tags Excel

`=(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

PS: the Brackets in the formula bar, highlighted that sometimes it is convenient. Also agree. - Leilani64 commented on September 26th 19 at 07:07