Hi Betsym
Try this instead of nested "If's"
=IF(TODAY()-B2<30,0,INDEX({30,60,90,120},1,MATCH(TODAY()-B2,{30,60,90,120},1)))&"
Days Overdue"
HTH
Alan P.
"BetsyW" wrote in message
...
I'm trying to set up a worksheet to age my accounts payable. I want to
determine 30 days, 60 days, 90 days etc.
My formula is:
=if((today()-b2)30,"30 days overdue")
Where b2 is the cell w/ my invoice date in it, and "30 days overdue"
appears
if the test is true. However, I need to insert tests for 60, 90, and 120
days as well. My help index talks about nested if functions, and even
gives
an example, but when I try to type it that way, it just gives me an error
message! Help!!
TIA
|