Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiply Function
Dear Folks,
I have a small laptop and i am using excel for cxounting stock in the warehouse i am working. For the fast use i am in one column eg. A1 3*5 A2 2*9 A3 10*28 There is any way that i can have the result of this number in the column B eg: B1 15 B2 18 B3 280 The problem is that for quick use i don't type the equal symbol in the first column, just the numbers. Can anyone help me with that problem? Thanks in advance... With regards Manos |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiply Function
Manos,
If it's always multiply, and always that format, try this =LEFT(A1,FIND("*",A1)-1)*RIGHT(A1,LEN(A1)-FIND("*",A1)) -- HTH Bob Phillips "Manos" wrote in message .. . Dear Folks, I have a small laptop and i am using excel for cxounting stock in the warehouse i am working. For the fast use i am in one column eg. A1 3*5 A2 2*9 A3 10*28 There is any way that i can have the result of this number in the column B eg: B1 15 B2 18 B3 280 The problem is that for quick use i don't type the equal symbol in the first column, just the numbers. Can anyone help me with that problem? Thanks in advance... With regards Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum/multiply function | Excel Worksheet Functions | |||
using multiply if function | Excel Worksheet Functions | |||
STEP MULTIPLY FUNCTION | Excel Worksheet Functions | |||
What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
is there a function that will multiply different cells | Excel Worksheet Functions |