Any Excel 2007 experts in the house?

[The Fatman]

This is driving me insane. I need Column G to give me column F - column B, unless F is empty.

I know I can cheat, and sort it so it only shows me rows where F is populated, then apply the formula to those specific cells. but that kills me if I need to add more data in at a later time. Is there any way to set the rule above to all of G?

 

[Tim]

Write a macro or some other Visual Basic script using an "if...then" statement, perhaps?

 

[farmkid]

If you want column G to remain empty, use this:
=IF(F1="","",F1-B1)

If you want column G to do be something else, replace the second "" with whatever you want G to be.

 

[Non Sync]

Alternate method:

=IF(ISBLANK(F1),"",F1-B1)