MrExcel Publishing
Your One Stop for Excel Tips & Solutions

There must be a simple answer


Posted by Daren on January 17, 2002 5:40 PM

In one cell I have a formula that returns the information in another formula. I need to test the value that is the result of that formula. But every time I test the cell it tests the information in the cell which is the formula and not the result which is a date.
Thanks


Posted by Tom Urtis on January 17, 2002 6:17 PM

If you could please provide the formulas and an example of expected results it would help us to help you better.

Tom Urtis

Posted by Tom D. on January 17, 2002 7:34 PM

Would VALUE(Referenced Cell) work? (NT)

Posted by Jer Mammy on January 17, 2002 9:05 PM

Thanks Tom D.

Thanks Tom D.