Thread: how do i make a value entered be * 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
BenjieLop
 
Posts: n/a
Default how do i make a value entered be * 2

BigAL921 Wrote:
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

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: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=495107

Reply With QuoteReply With Quote