Is anyone good at formula's for Excel. I have been struggling with one for about half a hour now (not used formulas in a long time and only to a basic level)
Basically I want a formula that will tell me if cell A is X or Y and then if its X if the date in cell B is 3 years ago but if its Y it needs to tell me if its 5 years ago. Is this possible?
So far I have only got a formula using the AND function that will tell me if Cell A is X or Y and if it is 3 years ago.
Last edited by isimba; 09-10-2012 at 10:47 AM.
Maybe
=IF(AND(A1="X",(YEAR(TODAY())-YEAR(B1))=3),"OK",IF(AND(A1="Y",(YEAR(TODAY())-YEAR(B1))=5),"OK",""))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
=OR(AND(K52<=DATE(2009,10,30),L52="X"),AND(K52<=DATE(2007,10,30),L52="Y"))
This is what I have come up with and seems to work. Thanks for the help though!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks