IF, THEN SYNTAX
Try this...
=IF(AB2=C1,B2,0)
Or...
=(AB2=C1)*B2
--
Biff
Microsoft Excel MVP
"BBABBZZ" wrote in message
...
HELP!!!
=IF(AB2, C1 THEN B2)
C1 IS A DATE....IF AB2 IS GREATER THAN OR EQUAL TO THAT DATE THEN INSERT
AMOUNT IN B2, IF NOT ENTER "0"
|