Nested IF statements

Discussion in 'Microsoft Office Specialist (MOS), Office 365' started by Rob1234, Oct 14, 2007.

  1. Rob1234

    Rob1234 Megabyte Poster Forum Leader

    940
    127
    114
    I want to write a nested IF statement in Excel that will look in a cell at a date and if that date is passed then in the cell next to it write "out of date" or if the date is within 30 days then it will say "Renewal date soon".

    I can write an IF Statement that does the first bit about being out of day but I can not add the second part properly.
     
    Certifications: A few.
  2. ManicD

    ManicD Byte Poster

    237
    4
    34
    Sorry its taken a while, i only saw your topic today.

    heres the if statement you want

    =IF(A1<TODAY(),"Out of Date",IF(A1<(TODAY()+30),"Renewal Date Soon","Everythings OK"))

    it assumes the date is in A1 so you need to change BOTH occurences of that to make it fit to your sheet

    That was a bit if a tricky one, I've not dont nested IF's in a long time, but its fin to play again, lol.

    Hope this is still usefull and youve not already found out
     
    Certifications: MCSA, N+, A+(Tech), ECDL
    WIP: 70-294, 70-298
  3. Rob1234

    Rob1234 Megabyte Poster Forum Leader

    940
    127
    114
    Thanks for that I had'nt found the answer (was about to give up).
     
    Certifications: A few.

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.