I have this file with three date columns. The first date column is Decision Date, and that column will either have a date or be zero.
I use the other two date columns to calculate the number of days between them in another column, column D. What I want to do in column E is the following:
if the Decision Date is 0 and the number in column D is between 0 and 90, then E2 should be 75%; if the number in D is between 91 and 150, E2 should be 50%;
if the number in D is >150, then E2 should be 25%.
I want to do the same thing when the Decision Date column has dates in it, with the following changes: if the number in D is between 0 and 210, E2 is 75%; if D is between 211 and 335, E2 is 50%; if D is >336, E2 is 25%.
I have attached a file with an example. Any help is greatly appreciated.