Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |