Forum Discussion
Formula issue and need your help Excel 2013
hello
I have been trying to work out how to put some formula into excel using various functions and come to a complete blank. What I have is a start date, end date, status column and I have a ...
Hi Martin,
IF doesn't work such way, you need nested IF for several conditions, like
=IF($B$1>E5,"Overdue",IF($B$1<D5,"Notyetstarted","Ongoing"))