The ability to set a condition to an Excel formula, such as obtaining a value, color or even a further formula based on a value of another specific cell or the result of another specific formula, is of fundamental importance.
Setting the formula might seem, at first glance, quite complicated, but in reality, once you understand the mechanism, it is quite intuitive.
The formula to keep in mind is the following:
First of all, it should be kept in mind that the result we want to obtain will be written in the cell in which we apply the formula with condition, so first we must choose the cell that will be subjected to the condition we have chosen.
+SE(cell coordinates to which to apply the condition =<> in this case set the condition itself, i.e. equal to, greater than, less than or different from the value of our interest; (result that we want to apply if the condition were to be true); (result that we want to apply if the condition were false))
+IF(test;value if positive;value if negative)
It is very important to accurately set the indicated punctuation, as if it were not adequately respected the formula would return the error value.
An example of formulas:
Simple
+IF(A1=0;3;4)
With double condition
+IF(A1=0;IF(A2=0,1,2);5)
Obviously references to other pages of the file or even to external links or multiple condition levels can be inserted.
Scrivi commento