I
I
Intakto2014-07-28 16:56:25
excel
Intakto, 2014-07-28 16:56:25

How to write a formula of several arithmetic operations in excel?

Hello!
Help someone who understands Excel, you need to write the following formula.
We divide the sum of cells L2 + M2 by 2, divide the result by cell J2, then multiply what we got by 100 (i.e. we get a percentage).
Or even better, teach how to solve such problems on your own, where to look, how to google, etc.
Thank you!

Answer the question

In order to leave comments, you need to log in

5 answer(s)
Y
Yuri Lobanov, 2014-07-28
@Intakto

It's strange that both respondents made mistakes :)
Here is your formula
However, I do not advise converting to percentages, leave it as a fraction, but for percentages to appear:
Right-click on the cell > Format cells ... > Number > Number formats: Percentage and set the required number of digits after the comma. This will make it easier to work with such numbers.
In order to learn, it is enough to read any Excel textbook for dummies or just Excel help. office.microsoft.com/en-us/novice/FX101820736.aspx - for example.

S
Sergey Nikolaevich, 2014-07-28
@Playmore

you select the cell in which the result will be, you start writing the formula by putting = in the formula field, then simple actions using brackets and operators (you can select cells with the mouse)
+ there is help f1 (being in the formula bar) and the formula constructor icon first
I write from the memory of the excel under no hand

S
Shetani, 2014-07-28
@Shetani

I can recommend the book
John Walkenbach / John Walkenbach - Microsoft Excel User's Bible

D
Dmitry Entelis, 2014-07-28
@DmitriyEntelis

=((L2+M2)/J2)*100
en.wikipedia.org/wiki/%D0%9F%D1%80%D0%B8%D0%BE%D1%...
Since the order may differ in different languages, it is better to actively use parentheses.
PS I didn’t understand what the difficulty is and what to google here

A
Alexander Taratin, 2014-07-29
@Taraflex


You drive in excel a training manual in Google
And you read university training manuals - you solve tasks.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question