If...then statements?

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

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).
 
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,"")
 
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,"")
 
Back
Top