1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Nested IF statements

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

  1. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    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

    782
    24
    69
    Thanks for that I had'nt found the answer (was about to give up).
     
    Certifications: A few.

Share This Page

Loading...