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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jennifer
    Replies:
    3
    Views:
    340
    Janice C.
    Nov 10, 2003
  2. Angie

    formulas in table

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

    WORD TABLE FORMULAS Forms

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

    Table with form fields: cell formulas

    Michael, Feb 2, 2005, in forum: Word Tables
    Replies:
    1
    Views:
    128
    Suzanne S. Barnhill
    Feb 2, 2005
  5. ChuckZ
    Replies:
    4
    Views:
    113
    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:
    101
    Doug Robbins
    Jun 5, 2005
  7. jaccs89

    MS Word Table Formulas??

    jaccs89, Aug 20, 2005, in forum: Word Tables
    Replies:
    2
    Views:
    82
    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:
    168
    garfield-n-odie [MVP]
    Jun 4, 2007
Loading...