B
BradP
I am creating a spreadsheet for the A/R person.
I have the balance owed, # of days the invoices is. I am creating
columns: 0-30, 31-60, 61-90, 91+. I would like the balance also to b
placed in the correct column. The spreasheet is about 1100 lines
I have a eq. that works but looking for an alternative one.
=IF(L8>=$Q$1,J8,0)+IF(L8<=$R$1,J8)-J8 - this works in the 61-9
column
L8 - Days Old
Q1 - 61
J8 - Balance
R1 - 9
I have the balance owed, # of days the invoices is. I am creating
columns: 0-30, 31-60, 61-90, 91+. I would like the balance also to b
placed in the correct column. The spreasheet is about 1100 lines
I have a eq. that works but looking for an alternative one.
=IF(L8>=$Q$1,J8,0)+IF(L8<=$R$1,J8)-J8 - this works in the 61-9
column
L8 - Days Old
Q1 - 61
J8 - Balance
R1 - 9