IF/AND Function
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
|