Answer the question
In order to leave comments, you need to log in
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
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)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question