Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Table Formulas | Tables | |||
Using Formulas in a Table | Tables | |||
TABLE - Formulas? | New Users | |||
Formulas in a Table | Microsoft Word Help | |||
Formulas in a Table | New Users |