Complex formula question

gebobs · #1 10-20-2014, 12:45 PM

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))

diverdown87 · #2 10-21-2014, 07:24 AM

Quote:

Originally Posted by gebobs

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))

Thanks gebobs the last one works great.

Only other question is there a way to make any of the ones that are within the 45, 30, and 15 days show as a -# and the rest as positive.

I really appreciate you help with this.

diverdown87 · #3 10-21-2014, 07:44 AM

Quote:

Originally Posted by diverdown87

Thanks gebobs the last one works great.

Only other question is there a way to make any of the ones that are within the 45, 30, and 15 days show as a -# and the rest as positive.

I really appreciate you help with this.

Nevermind gebobs, as you have it works exactly as I need. Please disregard above.

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
I need help for a complex projet at my job	Elok	Word	4	01-10-2013 08:28 AM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
SUMIF Formula question	jcaswell	Excel	3	05-22-2011 02:52 AM