S
Scrapyard
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
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