IF function (I think)

[BillDerr]

I am trying to use the IF function to display the value of another cell if the cell with =IF meets a certain value. I think IF is the way to do it but not getting anywhere - hope somebody can help.

For example in H9 I want if C9>1 display the value of B9

[erAck]

In H9 enter =IF(C9>1;B9;0)

The third argument 0 to the IF() function is the else or otherwise result value if C9 is not greater than 1, adjust to your needs.

See also Logical Functions.

[BillDerr]

Many thanks that works perfectly.