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)

Name1 Name2 Side Type Price PriceA PriceB Calc
Fred Blank Buy A 2 2 3 1
Blank Fred Sell A 5 4 6 1

Thank you in advance.

In cell H2:

=IF(AND(OR(A2="Fred",B2="Fred"),D2="A"),IF(C2="Sel l",G2-E2,E2-G2),"")

And copy down to match.

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
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)

Name1 Name2 Side Type Price PriceA PriceB Calc
Fred Blank Buy A 2 2 3 1
Blank Fred Sell A 5 4 6 1

Thank you in advance.

Thank you Bernie. If I change the logic slightly from:

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

To:

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

How would the formula change.

Also. If the formula is False, can I make it return 0 "zero" ?

Thank you again.



"Bernie Deitrick" wrote:

In cell H2:

=IF(AND(OR(A2="Fred",B2="Fred"),D2="A"),IF(C2="Sel l",G2-E2,E2-G2),"")

And copy down to match.

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
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)

Name1 Name2 Side Type Price PriceA PriceB Calc
Fred Blank Buy A 2 2 3 1
Blank Fred Sell A 5 4 6 1

Thank you in advance.

Assuming Name 3 is in column C, and everything in D:G shifts to the right, in cell I2, use

=IF(AND(OR(AND(A2="Fred",C2="Fred"),B2="Fred"),E2= "A"),IF(D2="Sell",H2-F2,F2-H2),0)

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
Thank you Bernie. If I change the logic slightly from:

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

To:

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

How would the formula change.

Also. If the formula is False, can I make it return 0 "zero" ?

Thank you again.



"Bernie Deitrick" wrote:

In cell H2:

=IF(AND(OR(A2="Fred",B2="Fred"),D2="A"),IF(C2="Sel l",G2-E2,E2-G2),"")

And copy down to match.

HTH,
Bernie
MS Excel MVP


"carl" wrote in message
...
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)

Name1 Name2 Side Type Price PriceA PriceB Calc
Fred Blank Buy A 2 2 3 1
Blank Fred Sell A 5 4 6 1

Thank you in advance.

=if(and(or(a1="fred",b1="fred"),d1="a"),if(c1="buy ",e1-g1,g1-e1))


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523627