Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-25-2014, 03:33 AM
Scrapyard Scrapyard is offline Help needed: Table Formulas with AND Windows Vista Help needed: Table Formulas with AND Office 2007
Novice
Help needed: Table Formulas with AND
 
Join Date: Jan 2014
Posts: 2
Scrapyard is on a distinguished road
Default

Interesting...
I always find strange ways of doing things. I determined leap year using the following method (items are bookmarked):

UserYear = 2016 (or any year the user inputs)
Leap1 = 1/29/UserYear
Leap2 = { If {Leap1 \@ MMMM } = "February" 1 0 }

So, maybe something like the following should work?
{ IF {=G8 } >= 31 { IF { { =G8 } =28 }*{ { =Leap2 } = 1} 29 "" } {IF { =G8 } ≠ 0 { =G8+1 } "" }}

Or maybe?
{ IF {({ =G8})*({ =Leap2})} =28 29 "" }
For some reason, I can't seem to get this to work. It always produces a 29 result; it appears as though =28 is an answer rather than a qualifier.

"≠" because I couldn't use greater/less than symbols in forum.

That said, I'll look at what you've provided. I can see that it does the most comprehensive check. I'm just not confident in my ability to incorporate it properly.
Thanks!

Last edited by Scrapyard; 01-25-2014 at 04:50 AM. Reason: Another Attempt
Reply With Quote
 

Tags
formula, table



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formulas barryjones Excel 2 06-03-2013 04:27 AM
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
Help needed: Table Formulas with AND Using subtotals in Pivot table formulas ninfanger Excel 3 10-23-2010 12:29 AM
Help needed: Table Formulas with AND IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM
Table formulas markg2 Word Tables 0 01-15-2010 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft