R
Roz
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.
=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.