Thread: [Solved] Complex formula question
View Single Post
 
Old 10-20-2014, 12:45 PM
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
Days Past = TODAY()-[Date Create cell]-VLOOKUP(A2,Level,2,FALSE)

Or if you don't want to create a table and do a lookup:

Days Past = TODAY()-[Date Create cell]-IF([Risk cell]="High",45,IF([Risk cell]="Severe",30,15))
Reply With Quote