Inserting the right formula in cell

[Seanni]

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.

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

 

[Joe4]

Anything enclosed in double-quotes is treated as literal text.
Just use:

=IF(B2>=16;B2;"")