Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
K
K
Kostya122017-10-12 09:19:56
Visual Basic
Kostya12, 2017-10-12 09:19:56

How to implement a loop in Excel?

Help me create a macro in Excel so that each cell that is less than 2 is multiplied by its neighbor and the sum is written in one cell

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
S
shushpanio, 2017-10-12
@shushpanio

Will the formula work?
For cell C2, write =IF(A2<2;A2*B2;A2)
On the screen, the result of the work.
Well, then do the sum by column

Similar questions
M
MegaTort2021-07-03 23:15:24
How to get object coordinates in Autocad using VBA\Python? 1Reply
H
Hosting Yaroslavl2018-03-12 15:09:49
Why does ADODC return "e_fail" status from data provider or other service when working with date? 0Reply
A
Alexey Smirnov2015-12-14 15:37:40
How can the IndexOf method (from the .NET framework) explain that inside the method's brackets, any text can be placed between some HTML tags? 1Reply
A
Alexey Smirnov2015-12-24 00:48:02
How, in an XML document, using the .NET framework, to get data from the text node of some element that has a certain attribute? 1Reply
A
Alexey Smirnov2015-12-30 20:13:36
How to write a macro in Excel that would “sort” a row of data from a cell into a table? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question