Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
need to save values from a function before it changes | Excel Worksheet Functions | |||
SUMIF(AND) FUNCTION | Excel Worksheet Functions |