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, Jan 25, 2014
    1. Advertisements

Ask a Question

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.