Two IF Statements with two answers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula for Eclipsing Circles 0
how can i use a whole number after dividing? 3
conditional formatting 5
IF statement - almost there! 5
Excel Formula Help? 5
An easier way? 9
help with a formula 2
Choose function 8

Back
Top