Monday, 15 April 2013

excel - if statement, need 3 results -



excel - if statement, need 3 results -

asked question earlier, can craft better. have 5 columns each, have dates entered. if date less 14 days, status column shows "current" if false shows "overdue". need add: if date entered 5th column status column show "complete"

right i'm envisioning...

but you're after , current setup unclear...

excel formula

No comments:

Post a Comment