Hello

Hello I need a formula to help with the following below.

The varaiables are Andy and Z both collect funds from the customer and
both ship products.

The partners split the profit and the shipper keeps the wholesale cost
in addition to the profit.

Columns A, B work out the two income levels all ok.
Column C works out who has collected the money and is due to pay it
to.
Column F works out who shipped all ok.

In this example Z collects the money and A ships so Z pays to A column
c funds ($62.50)

I need columns E to work out if A ships and Z collects funds, also need
column C to work out vice versa, I can ensure the opposite cell will
show as clear by using conditional formatting.


A Shippers Income $62.50

B Partner Income $32.50

C Money to be paid to Andy

D Andy pay to Z = $formula?? (answer $0) this example

E Z pay to Andy = $formula?? (answer $62.50) this example

F Shipped by Andy

Sorry for the vertical layout guys this software crunches the text
together if in normal excel panoramic view.

There may be a cleaner way of doing this guys, but I have tried and/if
statements and not had any success.

Thanks for your help

Mark


--
Markyboy
------------------------------------------------------------------------
Markyboy's Profile: http://www.excelforum.com/member.php...o&userid=29493
View this thread: http://www.excelforum.com/showthread...hreadid=498425