Help needed: Table Formulas with AND


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
 
Ad

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top