Forum Discussion
Solved
Excel Formula
Greetings of the day,
Example.
I have a category in data like officer & staff. in which I want to show the training due date by using the Edate formula. but where an officer is there, there should be shows "NA" & if there is staff in the category I want to run the Edate formula.
Please suggest ways to to do it.
6 Replies
- Thank you for the response.
But there is more in a category.
Ex. I want "NA" for Officer & Foreman, then Edate formula on Staff & FO.
Please suggest me formula for this.Kasafkhan Same principle but add the OR function and perhaps wiser to check for the ones that don't need training.
=IF(OR(A1="Officer",A1="Foreman"),"NA", EDATE(-----------))
- Thank you so much for such a quick response. I was stuck & exhausted on this. you relived me.👌👍
