Excel Formula


I'm new to using Excel Formulas; how would I write a formula to make the following happen? It is between three cells; if E18 has a number greater than 0, then F18 would autofill with the contents of C11. What would the formula be for this?

2 Replies
best response confirmed by mtarler (Trusted Contributor)
Excel formulas are designed to display the result of the formula in the cell they are entered. So in cell F18 type: =IF(E18>0,C11,"") which say if E18 is > 0 then show the value C11 otherwise show "" (blank)
Thank you! Works Perfect!