IF/AND Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sr Accountant - 25 Mar 2008 15:06 GMT

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(j1>0,"","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

Reply to this Message

duxxyy - 25 Mar 2008 15:48 GMT

If I get your problem correctly:

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

> 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.
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

duxxyy - 25 Mar 2008 16:20 GMT

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

sorry...

> If I get your problem correctly:
>
[quoted text clipped - 17 lines]
> >
> > Thanks

Reply to this Message

Sr Accountant - 25 Mar 2008 16:37 GMT

Thank you. This is exactly what I needed.

Have a good one.

> If I get your problem correctly:
>
[quoted text clipped - 17 lines]
> >
> > Thanks

Reply to this Message