software

I tried but cannot get a formula to give me the result.

I am looking for a formula for ColH (Calc) that will do the following:

If Name1 OR Name2 is Fred And Type is A, For Side=Sell (PriceB-Price), For
Side=Buy (Price-PriceB)

Name1Name2SideTypePricePriceAPriceBCalc
FredBlankBuyA2231
BlankFredSellA5461

Thank you in advance.Hi

Try this:
=IF(AND(OR(A2=quot;FREDquot;,B2=quot;FREDquot;),D2=quot;Aquot;),IF(C2=quot;BUY quot;,G2-E2,IF(C2=quot;SELLquot;,E3-G3,quot;quot;)))

Andy.

quot;carlquot; gt; wrote in message
...
gt;I tried but cannot get a formula to give me the result.
gt;
gt; I am looking for a formula for ColH (Calc) that will do the following:
gt;
gt; If Name1 OR Name2 is Fred And Type is A, For Side=Sell (PriceB-Price), For
gt; Side=Buy (Price-PriceB)
gt;
gt; Name1 Name2 Side Type Price PriceA PriceB Calc
gt; Fred Blank Buy A 2 2 3 1
gt; Blank Fred Sell A 5 4 6 1
gt;
gt; Thank you in advance.
gt;