LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default HELP!!! I give up!!! Help with formula

I am building a house, acting as my own general contractor. I am setting up
an Excel spreadsheet to track actual cost versus estimate so I'll know when
I'm running out of money.

I need to set up the spreadsheet with each cost item -- grading, fill,
footers, framing lumber, shingles, etc., etc. I then need to put an entry
for ESTIMATE, ACTUAL, DIFFERENCE. The DIFFERENCE column should conform to
these rules:
-- If ESTIMATE and ACTUAL are equal, nothing should appear in the DIFFERENCE
cell.
-- If ESTIMATE is greater than ACTUAL (that is, if I budgeted more than it
cost), then a positive dollar figure should show in DIFFERENCE.
-- If ESTIMATE is less than ACTUAL (if it cost more than I estimated), then
a negative number should appear in the DIFFERENCE cell (in parens on the
printout, in red on the screen).

For example:
Item Estimate Actual Difference
Fill $500 $475 $25
Form labor $800 $1,000 -$200
Plans $1,200 $1,200
(At this point I will show a total difference of -$175, thus, I will know
that I am $175 over budget.

I can't figure out the formula for the DIFFERENCE cells -- can someone help?

Thanks in advance.

--

-----
Joe S.


 
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
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
The same IF (SE) formula give me two different number: why??? -= Luca =- Excel Worksheet Functions 5 June 30th 06 01:30 PM
Formula to give archived name ForSale Excel Worksheet Functions 5 March 11th 06 03:12 AM
Can someone give me a hand with this formula please? Howie Excel Worksheet Functions 11 November 12th 05 12:19 AM
What can I add to a vlookup formula to give me a 0 not #n/a Casper Excel Worksheet Functions 4 July 5th 05 05:32 AM


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