Hi
I hope someone can help me with the problem i have .
I am trying to write formula which will show one of three words in one cell depends on the date from 2 other cells , the words are Due / Overdue / Achieved
The formula i wrote is :
I dont know where i am doing it wrong but at the moment its only showing me overduePHP Code:
=IF(G11="","",IF($I11<TODAY(),"OVERDUE",or IF($I11<=TODAY()-7,"Due",or IF(Q11<=TODAY(),"Achieved"))))
I would be grateful if someone can help me with this.
Bookmarks