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
- Sep 10 Mon 2007 20:39
how do i make a value entered be * 2
close
全站熱搜
留言列表
發表留言