Oh! I forgot to mention that the 6 formulas are all lumped into TWO cells
(either D or E) to find the value for both D and E. Hopefully that makes
sense.

Here's an idea of what I was messing around with, but that didn't work
(because it is assuming that if the first "if" is wrong then the second "if"
is correct, which is not the case. One of the "if"s will be correct and the
others will be wrong. I want the formula to check for which one to use):
=IF(D6="JB" =AND(E6="S"), C6/2,IF(D6="JB" =AND(E6="N"),C6,IF(D6="KT"
=AND(E6="S"), 0, "MESSUP")))

So basically, you are looking for the answer to both D and E from only
filling in columns A, B, and C.

"LubberLou" wrote:


I have a sheet of 5 columns. I'm trying to make a spreadsheet of costs
between two people to show who pays for what and what each person owes the
other. The columns look like this:

A - a varying amount (in dollars)
B - who the amount was paid by (either KT or JB)
C - whether or not the cost is a shared, non-shared, or paid cost (either
"s", "n", or "p" text-values)
D - what KT owes JB
E - what JB owes KT

Here's the thing. I want the amounts in columns D and E to change based on
the various combinations of B and C together. So here are the formulas:

If B=KT and C=S, then D=$0 and E=A/2
If B=KT and C=N, then D=$0 and E=A
If B=KT and C=P, then D=$-A and E=$0

If B=JB and C=S, then D=A/2 and E=$0
If B=JB and C=N, then D=A and E=$0
If B=JB and C=P, then D=$0 and E=$-A

I've tried using many, many different if formulas and none of them seem to
work correctly. Please help! Thanks so much!