Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-26-2011, 12:50 AM
J Morrow J Morrow is offline Embedded IF AND OR Formula Problem Windows XP Embedded IF AND OR Formula Problem Office 2007
Novice
Embedded IF AND OR Formula Problem
 
Join Date: Aug 2011
Posts: 4
J Morrow is on a distinguished road
Default Embedded IF AND OR Formula Problem

Team,



Please see attached. The upper section is my testing area for the formulas and the lower is the desired outcome. For the most part, the formula works with dates listed in the corresponding cells. However, there will be many cases of which instead of a date in column I (Calib Date), there will be entries of "NA" to indicate a calibration is not required. This is where my formula and additional attempts to tweak it fails such that I cannot obtain the desired status word in column E (Current Status) which contains the formulas.

Your help would be greatly appreciated.
Attached Files
File Type: xls Current Status Worksheet.xls (31.5 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded IF AND OR Formula Problem Embedded File Atlas Word 1 06-20-2011 04:37 PM
Embedded IF AND OR Formula Problem Embedded links spheon Word 1 06-07-2011 04:11 PM
Embedded IF AND OR Formula Problem Linking an image that is not embedded charismarl Word 1 02-25-2011 01:58 AM
Embedded in invitation? admin99 Outlook 0 08-28-2010 05:34 PM
Formula problem? markg2 Excel 11 06-10-2010 07:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 PM.


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