Help needed: Table Formulas with AND
This may sound odd... I'm building a document with an annual calendar that the user can update for any year.
I'm building the February Calendar, and I have determined a check for 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 that similar to the following, given that G8 = 28 and Leap2 = 1:
{ IF {=G8 }= 28
{ 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 of table formulas using IF and AND. NOTE: "≠" couldn't get it to show up using greater than/less than in the forum.
Thanks in advance!
Last edited by Scrapyard : January 25th 14 at 05:42 AM
|