argh!!!! The quotes!!!

Thank you!
--
Lori


"BekkiM" wrote:

Take the quotation marks out of the true value:

=IF(Historical!I10="X",Historical!A10,"")

"Lori Burton" wrote:

I have written a formula that looks like this:

=IF(Historical!I10="X","value(Historical!A10)","")

The true value returns "Historical!A10" rather than the value showing in the
cell. How do I fix this?
--
Lori