Help needed: Table Formulas with AND

Discussion in 'Word Tables' started by Scrapyard, Jan 25, 2014.

  1. Scrapyard

    Scrapyard Guest

    This may sound odd... I'm building a document with an annual calenda
    that the user can update for any year

    I'm building the February Calendar, and I have determined a check fo
    leap years, 0 for false 1 for true, bookmarked as Leap2

    I'm now down to the bottom row of the month. I want something tha
    similar to the following, given that G8 = 28 and Leap2 = 1

    { IF {=G8 }>= 2
    { IF {=AND({=G8}=28, {=Leap2}=1)}=1 {=G8+1} ""
    { IF { =G8} ≠ 0 {=G8+1} ""


    Now, my issue is purely with the syntax of using AND in this capacity
    If this formula doesn't make sense, I'd appreciate a few examples o
    table formulas using IF and AND. NOTE: "≠" couldn't get it to sho
    up using greater than/less than in the forum

    Thanks in advance


    --
    Scrapyard
     
    Scrapyard, Jan 25, 2014
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jennifer
    Replies:
    3
    Views:
    334
    Janice C.
    Nov 10, 2003
  2. Angie

    formulas in table

    Angie, Nov 17, 2003, in forum: Word Tables
    Replies:
    1
    Views:
    87
    Cindy M -WordMVP-
    Nov 17, 2003
  3. BigWylie1

    WORD TABLE FORMULAS Forms

    BigWylie1, Oct 26, 2004, in forum: Word Tables
    Replies:
    3
    Views:
    125
    Doug Robbins
    Oct 28, 2004
  4. Michael

    Table with form fields: cell formulas

    Michael, Feb 2, 2005, in forum: Word Tables
    Replies:
    1
    Views:
    124
    Suzanne S. Barnhill
    Feb 2, 2005
  5. ChuckZ
    Replies:
    4
    Views:
    107
    ChuckZ
    Feb 19, 2005
  6. Anthony  Dowd

    Formatting numbers in word table formulas

    Anthony Dowd, Jun 5, 2005, in forum: Word Tables
    Replies:
    1
    Views:
    96
    Doug Robbins
    Jun 5, 2005
  7. jaccs89

    MS Word Table Formulas??

    jaccs89, Aug 20, 2005, in forum: Word Tables
    Replies:
    2
    Views:
    77
    Doug Robbins
    Aug 20, 2005
  8. mnpremo

    Table of Figures and Table of Table

    mnpremo, Jun 4, 2007, in forum: Word Tables
    Replies:
    1
    Views:
    162
    garfield-n-odie [MVP]
    Jun 4, 2007
Loading...