Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How to set up a cost estimate spreadsheet?

I want to set up a spreadsheet that calculates a cost estimate based on hour
many hours are inputted against each person (each person having a different
hourly rate)
eg.
Person 1 $100
Person 2 $200
Person 3 $300

Is there anyway I can set it up so that so that if I enter '12' (for 12
hours) next to Person 1, it automatically calculates that person's total as
$1,200 and so on?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 91
Default How to set up a cost estimate spreadsheet?

If Name was A2
$$ amount was in B2
Hours were in C2

Type this in D2 =B2*C2 then enter

It appears you could use a crash course in Excel basics Here's a site
to get you started

http://usd.edu/trio/tut/excel/index.html

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default How to set up a cost estimate spreadsheet?

In case you don't want zeros to appear in column D until you enter some
hours in column C, you could amend the formula in D2 to:

=IF(C2=0,"",B2*C2)

and copy this down.

Hope this helps.

Pete

damorrison wrote:
If Name was A2
$$ amount was in B2
Hours were in C2

Type this in D2 =B2*C2 then enter

It appears you could use a crash course in Excel basics Here's a site
to get you started

http://usd.edu/trio/tut/excel/index.html


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
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Spreadsheet shortcuts not working brt Setting up and Configuration of Excel 2 April 26th 06 01:57 PM
Spreadsheet Security Lee Meadowcroft Excel Discussion (Misc queries) 0 April 6th 06 09:40 PM
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM
Conditional Cost allocation CotoJoe Excel Discussion (Misc queries) 0 September 14th 05 08:23 PM


All times are GMT +1. The time now is 11:20 AM.

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

About Us

"It's about Microsoft Excel"