How to implement a loop in Excel?

K

Kostya122017-10-12 09:19:56

Visual Basic

Kostya12, 2017-10-12 09:19:56

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

In order to leave comments, you need to log in

1 answer(s)

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

K

kariisha_nn2020-11-22 00:17:11

K

Kryptonit2022-04-19 11:36:59

D

docbrain2016-10-09 18:29:34

G

GODiDS2014-10-16 13:14:16

V

Vladislav2019-03-25 16:18:51

Didn't find what you were looking for?