Thread: What if statement
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
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




Reply With QuoteReply With Quote