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