Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying the number in one cell and providing the product in an
I've never set up a formula before, not even the most basic. I need help and
I'm not sure if its entirely possible. Please let me know. Labor Hours Labor Cost (95/hr) 2 190 5 950 I need to be able to enter in the number of hours in one cell (under labor hrs) and have those hours multiplied by the cost ($95) and the product displayed in the cooresponding cell (under labor cost). Is this possible? If so, how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying the number in one cell and providing the product in an
EXCEL 2007
1. In cell A2 I have put your 2 (your hours figure). 2. In cell B2 I have put 95 (being 95 dollars per hour). 3. I cell C2 I have put the formula:- =(A2*B2) The gives a result of 190 in cell C2. If my comments have helped please hit Yes. Thanks. "littlemissfish" wrote: I've never set up a formula before, not even the most basic. I need help and I'm not sure if its entirely possible. Please let me know. Labor Hours Labor Cost (95/hr) 2 190 5 950 I need to be able to enter in the number of hours in one cell (under labor hrs) and have those hours multiplied by the cost ($95) and the product displayed in the cooresponding cell (under labor cost). Is this possible? If so, how? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying the number in one cell and providing the product in an
Let's assume:
Cell A1 = header = Labor Hours Cell B1 = header = Labor Cost Enter the multiplier in a cell, also. Say cell C1 = multiplier = 95 A2:A3 are the hours worked Now, enter this formula in cell B2: =A2*C$1 With cell B2 still selected, notice the little black "square" on the bottom right of the selected cell? Hover your mouse over that little black square until the cursor changes from a fat + (plus) sign to a skinny + (plus) sign. When the cursor is a skinny + (plus) sign click and hold the left mouse button then drag the cursor down the column to cell B3. Release the left mouse button. -- Biff Microsoft Excel MVP "littlemissfish" wrote in message ... I've never set up a formula before, not even the most basic. I need help and I'm not sure if its entirely possible. Please let me know. Labor Hours Labor Cost (95/hr) 2 190 5 950 I need to be able to enter in the number of hours in one cell (under labor hrs) and have those hours multiplied by the cost ($95) and the product displayed in the cooresponding cell (under labor cost). Is this possible? If so, how? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying the number in one cell and providing the product i
Thank you, but I can't have cell C2. I need the hours in cell A2 and the
product result of A2*95 to show in cell B2. I want to be able to enter the amount of hours in cell A2 and have them automatically multiplied by $95.00 showing the product ($190.00) in cell B2. I hope that make sense. "trip_to_tokyo" wrote: EXCEL 2007 1. In cell A2 I have put your 2 (your hours figure). 2. In cell B2 I have put 95 (being 95 dollars per hour). 3. I cell C2 I have put the formula:- =(A2*B2) The gives a result of 190 in cell C2. If my comments have helped please hit Yes. Thanks. "littlemissfish" wrote: I've never set up a formula before, not even the most basic. I need help and I'm not sure if its entirely possible. Please let me know. Labor Hours Labor Cost (95/hr) 2 190 5 950 I need to be able to enter in the number of hours in one cell (under labor hrs) and have those hours multiplied by the cost ($95) and the product displayed in the cooresponding cell (under labor cost). Is this possible? If so, how? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiplying the number in one cell and providing the product i
Do this then:-
1. In A2 is the 2 that you mention. 2. B2 is:- =(A2*95) - giving a result of 190 in cell B 2. If my comments have helped please hit Yes. Thanks. "littlemissfish" wrote: Thank you, but I can't have cell C2. I need the hours in cell A2 and the product result of A2*95 to show in cell B2. I want to be able to enter the amount of hours in cell A2 and have them automatically multiplied by $95.00 showing the product ($190.00) in cell B2. I hope that make sense. "trip_to_tokyo" wrote: EXCEL 2007 1. In cell A2 I have put your 2 (your hours figure). 2. In cell B2 I have put 95 (being 95 dollars per hour). 3. I cell C2 I have put the formula:- =(A2*B2) The gives a result of 190 in cell C2. If my comments have helped please hit Yes. Thanks. "littlemissfish" wrote: I've never set up a formula before, not even the most basic. I need help and I'm not sure if its entirely possible. Please let me know. Labor Hours Labor Cost (95/hr) 2 190 5 950 I need to be able to enter in the number of hours in one cell (under labor hrs) and have those hours multiplied by the cost ($95) and the product displayed in the cooresponding cell (under labor cost). Is this possible? If so, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiplying a negative number | Excel Discussion (Misc queries) | |||
Providing a reference to another cell in a different workbook | Excel Worksheet Functions | |||
Formula or Function providing Mile value in a cell from 2 addresse | Excel Worksheet Functions | |||
Multiplying time by number | Excel Discussion (Misc queries) | |||
multiplying a cell by a set number | Excel Discussion (Misc queries) |