Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
Spreadsheet Security | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Conditional Cost allocation | Excel Discussion (Misc queries) |