| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i make a value entered be * 2
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
| how do I make drop-down list select based on 1st letter entered? | Excel Discussion (Misc queries) | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Make a cell blank? | Excel Worksheet Functions | |||
Linear Mode
