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