View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default 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?