Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using Excel 2007; I am trying to write a conditional formula. What I
essentially want is that if the date is less than 60 days I want the status to show pending, if the date is between 60 and 180 days I want to follow up with what I have to do and after 180 days, I would like it to show completed or something like that. So far I have =IF(M860,"FOLLOWUP", IF(M8180,"OK")) excel won't let me put in more data, and when I've played with the dates I'm not too entirely sure if this works either..... And my formula for the dates is fine, I'm just not sure what to do for this one. -- Thank you! Shelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formula | Excel Worksheet Functions | |||
conditional formula | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel |