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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()