Thread: IF, THEN SYNTAX
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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"