Hi please see the following attached spreadsheet.
I need to populate col D.
What I want the forumnla to do is look in col C, if it equals "HBI", then look in col J, then if col C says HBI and col J is greater than the date 30th sept 2013, then input in Col D HBI Evolutions. If col C does not have HBI return blank, if col C is HBI but is before 30th sept 2013, then return HBI.
thanks
Try
="HBI "&IF(AND(C2="HBI",J2>DATEVALUE("30/09/2013")),"Evolutions","")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
thx it's perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks