SOLVED

Excel Formula

Contributor

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)
Solution
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!