Two IF Statements with two answers

H

heater

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.
 
P

Peo Sjoblom

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
 
H

heater

Thanks!

Peo Sjoblom said:
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
Click to expand...
 
Top