software

Hi again! I have a cell in excel that has this formula:
=AND(E3lt;D3,TODAY()gt;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: www.excelforum.com/member.php...oamp;userid=29746
View this thread: www.excelforum.com/showthread...hreadid=494970Roz

Using a UDF you can evaluate E3 to 4 if it has 3 1 entered.

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

Copy/paste to a general module in your workbook.

CF formula =AND(EvalCell(E3)lt;D3,TODAY()gt;G3)Gord Dibben Excel MVP

On Tue, 20 Dec 2005 12:57:21 -0600, Roz
gt; wrote:

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