Thread: [Solved] Complex formula question
View Single Post
 
Old 10-21-2014, 07:44 AM
gebobs gebobs is offline Windows 7 64bit 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