Combining IF with AND

G

Guest

I'm trying to compare totals in 3 columns, in order to share expenses among three people, and then apply these totals to three different two-way relationships based on the totals (if one guy is in the black, then two are in the red and they each owe the first guy $; if two are in the black, then the third owes both of them $), so that two-way debts can also be figured in. Any ideas?
 
F

Frank Kabel

Hi
not quite sure what you're trying to do. could you give an example with
real values and your expected result?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula, Pivot Table, ??? Beats me 2
Presentation vs. data analysis - two or three hypotheticalprojections 1
Formula refrencing cell with a value of adjacent cell 7
How do you use multiple if formulas with multiple choices? 6
Complex IF THEN statement 5
Conditional formating a cell containing a date 1
I want a template for shared rent expenses 1
Overwriting a cell with a formula without deleting the formula 1

Top