Thanks!
"Peo Sjoblom" wrote:
If there are no other alternatives that yes and no
=IF(G9="Yes",F9,-F9)
otherwise
=IF(G9="Yes",F9,IF(G9="No",-F9,"")
Regards,
Peo Sjoblom
"heater" wrote:
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.
|