If your date is in F4 and your data to calculate is in G4, use this
formula:
=IF(YEAR(F4)=1999,G4*0.75,"not 1999")
You don't say what to do if the year is not 1999, so in my example I
simply return a text entry that tells you the year isn't 1999.
Does this work for you?
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=473458