close

I want to make the value of the number I enter be * 2
example: if I put in 1 i want it to equal 2 in my sum in another column
can anyone help me


BigAL921 Wrote:
gt; I want to make the value of the number I enter be * 2
gt; example: if I put in 1 i want it to equal 2 in my sum in another
gt; column
gt; can anyone help me

This is probably what you need. Enter this in, say, Cell B1

=2*A1

where A1 will contain any value that you want as your input.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=495107

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

    software

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