Multiplying the number in one cell and providing the product i
in [General]
|
Prev: Multiplying the number in one cell and providing the product in an
Next: ODBC connection from Excel 2008 on Mac OS X
From: littlemissfish on 24 Mar 2010 14:42 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?
From: trip_to_tokyo on 24 Mar 2010 14:55
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? |