Thread: If function
View Single Post
  #1   Report Post  
BetsyW
 
Posts: n/a
Default If function

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