M
Markyboy
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
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