If statement help

[Jazzer]

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I’m looking for an IF Statement which will hopefully be able to solve the following conundrum<o></o>
<o></o>
Column F contains four variations of text<o></o>
<o></o>
Opening Leg (Buy)<o></o>
Opening Leg (Sell)<o></o>
Closing Leg (Buy)<o></o>
Closing Leg (Sell)<o></o>
<o></o>
Column G contains numerical amounts (all positive)<o></o>
<o></o>
I would like column H to contain the exact amount in column G if column F contains Opening Leg (Buy) or Closing Leg (Sell)<o></o>

The amount in column G should be displayed as a negative in column H if column F contains Opening Leg (Sell) or Closing Leg (Buy)<o></o>
<o></o>
Many Thanks<o></o>
James<o></o>
<o></o>

 

[auto.pilot]

Something like this:


=IF(OR(F4="Opening Leg(Sell)",F4="Closing Leg(buy)"),-G4,G4)

 

[jasonb75]

One way would be

=choose(match(F2,{"Opening Leg (Buy)","Opening Leg (Sell)","Closing Leg (Buy)","Closing Leg (Sell)"},0),G2,-G2,-G2,G2)