I
I
IndependentFM2022-02-02 11:14:07
Google Sheets
IndependentFM, 2022-02-02 11:14:07

Google Sheets: how to use an IF statement to perform multiple actions when a condition is met?

The question is the following - how can one perform at least two values ​​of the conditions using the IF statement?
Example: A calculation is in progress in cell A1. As soon as the number in the cell is greater than 30, I want the cell to reset its value to zero, and cell B2 to increment.
Based on the syntax, as if only one outcome is possible - either the cell is reset to zero, or B2 is incremented, or something else, but only one.
Unfortunately, the AND operator allows you to specify several conditions for execution and nothing more.
Thanks in advance for your reply!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander, 2022-02-02
@IndependentFM

Suppose now you have a formula in A1 =FormulaX
Now it will be like this:
A1 \
=IF(FormulaX>30;"";FormulaX)
u003d B2 \u003d
=IF(FormulaX<=30;"";FormulaX)

D
dollar, 2022-02-02
@dollar

Cell B2 needs the same IF, with the same condition, but with a different action (increment).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question