close
I have a formula that looks likes this:
=IF(Historical!I10=quot;Xquot;,quot;Historical!A10quot;,quot;quot;)
If true, it returns quot;Historical!A10quot;
How do I write this formula to give me the value of A10 and not the name of
the cell?
--
Lori
=IF(Historical!I10=quot;Xquot;,Historical!A10,quot;quot;)Vaya con Dios,
Chuck, CABGx3quot;Lori Burtonquot; wrote:
gt; I have a formula that looks likes this:
gt;
gt; =IF(Historical!I10=quot;Xquot;,quot;Historical!A10quot;,quot;quot;)
gt;
gt; If true, it returns quot;Historical!A10quot;
gt;
gt; How do I write this formula to give me the value of A10 and not the name of
gt; the cell?
gt; --
gt; Lori
全站熱搜