LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 84
Default Help with Conditional Formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formula john Excel Worksheet Functions 3 November 1st 08 02:06 AM
conditional formula Anthony Excel Discussion (Misc queries) 1 September 13th 07 11:45 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Formula, Conditional Formula Needed Karl Excel Discussion (Misc queries) 12 June 23rd 07 04:12 AM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"