close

Hi, am trying to make an equation that varies the start point within a range.
Can I use a fixed cell to designate another non-fixed cell? thanks

such as: (for range: f10:M10)..

=IF(AND($A$3=4,$A$4=2),work g11:j11)nastech wrote:
gt; Hi, am trying to make an equation that varies the start point within
gt; a range. Can I use a fixed cell to designate another non-fixed cell?
gt; thanks
gt;
gt; such as: (for range: f10:M10)..
gt;
gt; =IF(AND($A$3=4,$A$4=2),work g11:j11)

By equations I take it you mean formula.

Look at the INDEX and OFFSET functions.

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

    software

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

    E-mail轉寄