Hi everyone,

I'm working in an Excel Database using the Dataform to enter data. I need a
single formula to do several things. Maybe you can tell by the formula I
tried to write, which doesn't work, naturally. It looks like this:
=IF(6:6,SUM(C3+E6)-F6),IF(COUNT(E7:F7)<1,"",G6+E7-F7)

Basically, if this IS G6, add C3 (which is outside the database)+E6-F6, but
if it's NOT G6, then add G6 + E7 - F7. All this needs to go into cell G6.

If I can get it all into that first formula cell (G6), then the formula will
automatically copy down as I enter data into the form ,and it can be sorted
based on the date in row 6 without the formula/calculation going nuts.

Your help is appreciated!
-----
smither fan