View Single Post
  #1   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 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?