close

I need help please!!! For example if I am in cell C3. I want to put a formula
in that if in B3 the number I have entered is between 4 and 6 for example
than i want the answer in C3 to be 2.

quot;Princessquot; wrote:
gt; I want to put a formula in that if in B3 the number I
gt; have entered is between 4 and 6 for example
gt; than i want the answer in C3 to be 2.

You also need to specify what value you want if B3 is not
between those limits. I will use 1 ....

=IF(AND(4lt;=B3,B3lt;=6), 2, 1)

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

    software

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

    E-mail轉寄