Microsoft Office Forums - View Single Post - [Solved] Complex formula question

Thread: [Solved] Complex formula question

View Single Post

Old

10-20-2014, 12:43 PM

diverdown87 diverdown87 is offline

diverdown87 is offline

diverdown87 uses Windows 7 64bit

Windows 7 64bit diverdown87 uses Office 2010 64bit

diverdown87 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Oct 2014

Posts: 5

diverdown87 is on a distinguished road

Default

I was able to get partial formula to work using the following statement: =IF(L3="SEVERE",-30,IF(L3="CRITICAL",-15,IF(L3="HIGH",-45,)))

Now all I need is to be able to somehow incorporate =Today ()-C3 into it along with showing a negative number for those that fall withing their respective due dates.

Reply With Quote