Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2014, 07:44 AM
gebobs gebobs is offline Complex formula question Windows 7 64bit Complex formula question Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I think that's just how it should display. For the examples you provided, the calculations come to:

High 23-Dec 257
Severe 25-Mar 545


Critical 13-Oct -7

Right? This last is the only one that is "within the 45, 30, and 15 days". It displays as negative.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula question H28Sailor Excel 4 08-20-2013 09:57 AM
Complex Formula using INDEX and Match needed OTPM Excel 5 05-23-2013 01:22 AM
Complex formula question I need help for a complex projet at my job Elok Word 4 01-10-2013 08:28 AM
Complex formula question Complex array formula andrei Excel 9 02-03-2012 03:40 AM
Complex formula question SUMIF Formula question jcaswell Excel 3 05-22-2011 02:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 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