If statement formula/challenge
 

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 B C D E
F
Shippers Partner Money Andy to Z to Shipped
Income Income Paid To Pay Z pay Andy By

$62.50 $32.50 A $formula?? $formula?? A


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=498410

If statement formula/challenge
 

See response in Excel.misc

--
Regards

Roger Govier


"Markyboy" wrote
in message ...

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 B C D E
F
Shippers Partner Money Andy to Z to Shipped
Income Income Paid To Pay Z pay Andy By

$62.50 $32.50 A $formula?? $formula?? A


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=498410