Numbers help

Discussion in 'iOS 5 and earlier' started by BerGaur, Jul 24, 2012.

  1. BerGaur macrumors regular

    BerGaur

    Joined:
    Dec 12, 2011
    Location:
    Inside my head
    #1
    I have made a calendar based spread sheet witch counts hours. It is very detailed and is heard to find the correct date so I can log hours in. I want to be able to have the day highlighted in some way. Maybe by having the cell directly above it bassically saying:

    =((2B)IF, true=today, printf"Today", IF, false (leave blank))

    Now I know this is totally wrong, I don't know a lot of code at all, and I never learned IF commands. I hope this is close enough to give the point of what I want to do. Please help.
     
  2. BerGaur thread starter macrumors regular

    BerGaur

    Joined:
    Dec 12, 2011
    Location:
    Inside my head
    #2
    OH I'M GOOD! I found out what it is.

    It is this:

    =IF(B2=TODAY, "Today", " ")

    Now, if TODAY is TRUE, it will print, "Today", and if TODAY is FALSE, it will print, " ".

    In other words, if "B2" shows today's date, it will print, "Today" in the "IF" field, and if it shows anything other than today's date, it will literally print a space.
     

Share This Page