I have a spreadsheet that we are tracking billing statements for Medical
Records, and I am struggling to get my formula to work the way I want it to.
We send a past due notice at 30, 60 and 90 days if no payment has been
received.

I have tried to right an IF statement as follows:
=If(TODAY()-A1)30,"3-","") This works for just the aging process, but I
would prefer it give me the 30, 60 or 90, PLUS if my amount column has
anything in it, leave the aging section blank. I can write my separate
amount formula as follows: =IF(j10,"","30"), but this is not accurate as
it's not pulling the date correctly.

I hope this makes sense, and if anyone can enlighten me, I would greatly
appreciate it.

Thanks

If I get your problem correctly:

=IF(C13<""; ""; IF($B$7-D1390; "over 90!"; IF($B$7-D1360; "over 60!";
IF($B$7-D1330; "over 30!"; "no rush yet..." ) ) ) )


"Sr Accountant" wrote:

I have a spreadsheet that we are tracking billing statements for Medical
Records, and I am struggling to get my formula to work the way I want it to.
We send a past due notice at 30, 60 and 90 days if no payment has been
received.

I have tried to right an IF statement as follows:
=If(TODAY()-A1)30,"3-","") This works for just the aging process, but I
would prefer it give me the 30, 60 or 90, PLUS if my amount column has
anything in it, leave the aging section blank. I can write my separate
amount formula as follows: =IF(j10,"","30"), but this is not accurate as
it's not pulling the date correctly.

I hope this makes sense, and if anyone can enlighten me, I would greatly
appreciate it.

Thanks

where the C column contains the amounts paid
B7 contains "=today()"
and the D column contain the due dates

sorry...

"duxxyy" wrote:

If I get your problem correctly:

=IF(C13<""; ""; IF($B$7-D1390; "over 90!"; IF($B$7-D1360; "over 60!";
IF($B$7-D1330; "over 30!"; "no rush yet..." ) ) ) )


"Sr Accountant" wrote:

I have a spreadsheet that we are tracking billing statements for Medical
Records, and I am struggling to get my formula to work the way I want it to.
We send a past due notice at 30, 60 and 90 days if no payment has been
received.

I have tried to right an IF statement as follows:
=If(TODAY()-A1)30,"3-","") This works for just the aging process, but I
would prefer it give me the 30, 60 or 90, PLUS if my amount column has
anything in it, leave the aging section blank. I can write my separate
amount formula as follows: =IF(j10,"","30"), but this is not accurate as
it's not pulling the date correctly.

I hope this makes sense, and if anyone can enlighten me, I would greatly
appreciate it.

Thanks

Thank you. This is exactly what I needed.

Have a good one.

"duxxyy" wrote:

If I get your problem correctly:

=IF(C13<""; ""; IF($B$7-D1390; "over 90!"; IF($B$7-D1360; "over 60!";
IF($B$7-D1330; "over 30!"; "no rush yet..." ) ) ) )


"Sr Accountant" wrote:

I have a spreadsheet that we are tracking billing statements for Medical
Records, and I am struggling to get my formula to work the way I want it to.
We send a past due notice at 30, 60 and 90 days if no payment has been
received.

I have tried to right an IF statement as follows:
=If(TODAY()-A1)30,"3-","") This works for just the aging process, but I
would prefer it give me the 30, 60 or 90, PLUS if my amount column has
anything in it, leave the aging section blank. I can write my separate
amount formula as follows: =IF(j10,"","30"), but this is not accurate as
it's not pulling the date correctly.

I hope this makes sense, and if anyone can enlighten me, I would greatly
appreciate it.

Thanks