View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christina
 
Posts: n/a
Default IF function with date

This seems really basic, but I looked and looked and couldn't find an
answer....

A B C
Date Wage OT Calc
2/1/2000 $7.50
1/1/2000 $8.00

In column C, I want the calculation to take the wage and double it, if the
date in A1 is on or after 2/1/2000. Thanks in advance!