Hi again! I have a cell in excel that has this formula:
=AND(E3<D3,TODAY()G3). I sometimes need E3 to display something like
3+1, meaning that I received two different shipments. I want excel to
be able to calculate the 3+1, while still performing the formula
mentioned above. I don't need excel to display the answer to 3+1, but
I need it to know the answer and recognize that 3+1 received items is
equal to the 4 items ordered. Thanks.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=494970