::undefined::undefinedTo create a cash-flow spreadsheet of balances
overdue by 30, 60 and 90 days respectively, as well as those same
increments upcoming in the future, I painstaking built the formula:
*=IF(AND(Y100,Y10<=30),X10,"")*, where X10 is the balance overdue by
0-30 days. The spreadsheet works fine because the columns for 31-60
days, 61-90 days, and 90 days each contain the appropriate values for
Y10, respectively.

I copied and modified these four columns to eight to see who had future
balances by the same four increments. The resuslt is a clean spreadsheet
where eight columns return accurate results as the balances age.

But, all that was for Installment #1 only. I just learned that I'm
expected to display, on the same spreadsheet, similar results for
Installments #2, #3 and even #4 if they exist. And my boss doesn't want
a 32-column spreadsheet!

Since I can't put more than one formula in one cell, can I nest my
formula within other IF(AND formulas or am I on the wrong track here?
I've been researching Arrays but I don't think that's the answer.

Any help would be greatly apppreciated as I'm nearly ready to replicate
the successful spreadsheet on three additional tabs which would mean
that management would have to toggle among four separate tabs to see
who owes what at any given time.

Thank you very much.


--
wellfm
------------------------------------------------------------------------
wellfm's Profile: http://www.excelforum.com/member.php...o&userid=27797
View this thread: http://www.excelforum.com/showthread...hreadid=473028