how do i make a value entered be * 2

B

BigAL921

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
 
B

BenjieLop

BigAL921 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top