Hi everyone,
I would like to insert a formula in the 3rd column (shown below), based on certain conditions:
If the value in the 2nd column is equal or higher than 16, the number itself should be inserted in column 3;
If the value in the 2nd column is below 16, the cell should be empty.
I've been trying with the IF-function, but can't manage to get anything better than:
=IF(B2>16; "=B2"; "")
However, this results in "=B2" literally being inserted in the cell (and not the value).
Anybody know how to create this?
Kind regards,
S
I would like to insert a formula in the 3rd column (shown below), based on certain conditions:
If the value in the 2nd column is equal or higher than 16, the number itself should be inserted in column 3;
If the value in the 2nd column is below 16, the cell should be empty.
Scenario | E. | E.1 |
1 | 9 | |
2 | 16 | |
3 | 5 | |
4 | 18 | |
5 | 17 | |
6 | 15 |
I've been trying with the IF-function, but can't manage to get anything better than:
=IF(B2>16; "=B2"; "")
However, this results in "=B2" literally being inserted in the cell (and not the value).
Anybody know how to create this?
Kind regards,
S