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?
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)