View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sharon t sharon t is offline
external usenet poster
 
Posts: 11
Default What if statement

I am trying to enter a what if statement in column C that will net the
results specified below:

A B C D
11/14/06 12/22/06 $50,000
03/19/07 12/22/06 $50,000

Results entered in column C; if A1 is equal to or greater than B1, then
subtract $50,000 from D1