=IF(G9="Yes",F9,-F9)
"heater" wrote in message
...
In cell J9 I need a formula that would do the following:

If G9="Yes" then F9, If G9="No" then -f9

Note: G9 has a drop down list with Yes, No answers.