If...then statements?
 

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).

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).

If...then statements?
 

How about
=if(len(2003!c4)0,2003!c4,"")

"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).

If...then statements?
 

I received a response (below) from someone on www.developersdex.com and it
works wonderfully. Thank you Developersdex.

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).