Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

If, and question [Closed]

Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 -
Hello,
I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a concrete slab and enter date in that cell another cell would populate to 20% and so on. Would probably have 6 different cells that would trigger a chance in percentage as the job progresses in that one cell that keeps track of percentage . Date in roof installed cell other cell goes from 20%to 45%. I've tried everything I know and have searched this all day. Thanks for any help.


See more

1 reply

Answer 1 / 1

20% of what?

I encourage you to stick around, because we may know of a couple things about the building process, and timelines, and materials, and automatic triggers of such!
I have said it once, I will say it again. IT!
Report

Thanks. 20% is basically what a slab pour represents in the building process example. 10% underground plumbing, 20% slab pour, 45% shingles installed, 70% drywall hung, 90% cabinets installed, 100% sod installed. I have individual cells for each event and put the dates the activity happens in those cells. Wanting the percentage cell to update each percentage (date in slab pour cell, percentage cell auto populates to 20%.when shingles go on I plug in date and the 20% turns to 45%,hope I'm explaining this. Thanks again.
Report
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 24
Assuming the layout of your page is like this: 
Activity	Percentage	Date
Plumbing	10%	        1/1/2015
Slab	        20%	        2/15/2015
Shingles 	45%	        3/12/2015
Drywall	        70%	
Cabinets	90%	
Sod	        100%


Percentage complete is: 
Work Done
45%


The formula for Work Done is:
=OFFSET(B1,MATCH(MAX(C2:C7),C2:C7,0),0)
Ask a question