I just tried it again in your test sheet and it worked no problem. When
the formula error message comes up, click on Ok and the place where the
error is will highlight in your formula toolbar. It's probably missing
a character for instance, if you typed the formula in as

=IF(AND(G6="",G7""),"",IF(G7<G6,G7+1-G6,G7-G6))

It would give you an error because the G7"" is not valid, it needs the
= sign.

=IF(AND(G6="",G7=""),"",IF(G7<G6,G7+1-G6,G7-G6))

Double check for typos.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499703