'Create if formula
I would like to create a cell call points. It looks at another cell (i8) and if that cell is greater then 15 it gets 2 points. If it is between 16-25 it gets 1 point, if it is greater then 25 it gets zero points.
This is for google sheets if value is =<15 gets 2 pts 16-25 gets 1 pt
25 gets zero points
Solution 1:[1]
use:
=IF(I8<=15; 2;
IF(I8<=25; 1;
IF(I8>25; 0)))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |