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?
|