Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tanker350
 
Posts: n/a
Default Simple Calculating Costs

I have been given an assignment for school. I need to use Excel but do not
have any experience with it.

I need to develope a model for calculating the cost to re-carpet our
classroom. Our instructor is emphasizing the quality of the model being
important.

Where should I start, any ideas to lead me. Thank-you

Thank-you

  #2   Report Post  
Jezebel
 
Posts: n/a
Default Simple Calculating Costs

Make a list of the variables (floor area, cost per square meter, and
whatever else is in the formula).

Assign one cell for each variable. Enter a caption so it's obvious what the
cell contains.

Assign a name for each of the cells containing data.

Assign a cell for the result. Add a caption, and explanation if there's
anything to explain.

Enter the formula, using names rather than cell references.

Put a bit of effort into making the sheet *look* good.



"Tanker350" wrote in message
...
I have been given an assignment for school. I need to use Excel but do not
have any experience with it.

I need to develope a model for calculating the cost to re-carpet our
classroom. Our instructor is emphasizing the quality of the model being
important.

Where should I start, any ideas to lead me. Thank-you

Thank-you



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
Sheet has stopped calculating... mailrail Excel Discussion (Misc queries) 1 July 13th 05 05:10 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! RICHARD Excel Discussion (Misc queries) 0 March 1st 05 01:53 PM


All times are GMT +1. The time now is 02:46 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"