IF formula needed

Copper Contributor

I need an if formula for this situation.  

If Debit is in column G, I want the value in column F reflected in column H as a negative number.

If Debit is not in column G, I want the value in column F reflected in column H as a positive number. 

 

alloyd1965_0-1652813699917.png

 

1 Reply
=if(G2="debit",f2*(-1),f2)