Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiplying a negative number M.A.Tyler Excel Discussion (Misc queries) 3 January 26th 09 07:40 AM
Providing a reference to another cell in a different workbook Darren Excel Worksheet Functions 2 May 25th 07 11:32 PM
Formula or Function providing Mile value in a cell from 2 addresse Blue Max Excel Worksheet Functions 2 November 13th 06 03:36 PM
Multiplying time by number God's Kid Excel Discussion (Misc queries) 3 January 27th 06 10:16 PM
multiplying a cell by a set number gunny86 Excel Discussion (Misc queries) 2 September 7th 05 07:52 AM


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"