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

What if statement
 

Did you look in the help index for IF
=if(a1=b1,d1-50000,"what do you want to do")

--
Don Guillett
SalesAid Software

"sharon t" wrote in message
...
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

What if statement
 

Thanks.

"Don Guillett" wrote:

Did you look in the help index for IF
=if(a1=b1,d1-50000,"what do you want to do")

--
Don Guillett
SalesAid Software

"sharon t" wrote in message
...
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