All formulas read values. Some values are hard-coded and some are the result
of other formulas' calculations.

So what are you trying to do here? If A4=C5 and you want to test if A5 is
less than A4, you could just enter in, say B2: =IFA4A5,"bigger","smaller"
Excel will look at A4, see its reference to C5 and calculate based on the
value in C5. And if C5 contains a formula, it will iterate the process until
it finds a final value.

Dave
--
Brevity is the soul of wit.


"Andrea" wrote:

Is it possible to build a formula that reads the value in a cell (that
references another cell) versus reading the formula in a cell?

For example, if a greater than value: IF A4A5, but the value in A4 is a
reference from another table, is there a way to do this, so the formula reads
the value, not the formula within the cell?

Thanks!
--
Andrea