View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default If...then statements?

Julie,

Yes, you can use an IF function in a formula. The general syntax is

=IF(test,result_if_true,result_if_false)

So, in your case, the formula would be

=IF('2003'!C44<"",'2003'!Q44,"")




"Julie" wrote in message
...
Windows98
Excel 2000

Is it possible to write an if...then statement instead of a formula? In

the
cell C43 on the Budget 2003 worksheet I would like to put in the if...then
statement:

=if ('2003'!C44) is not null then ('2003'!Q44)

Or is there a better way of doing this:
If there is a value in cell ('2003'!C44) then I need the value that is in
cell ('2003'!Q44) put into cell ('Budget 2003'!C44).