Previous Topic Next Topic

If, and question

Closed
Mike - Jan 28, 2016 at 07:38 PM
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 - Jan 28, 2016 at 11:01 PM
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.


1 reply

Answer 1 / 1
Blocked Profile
Jan 28, 2016 at 08:46 PM
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!
0
Mike
Jan 28, 2016 at 09:40 PM
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.
0
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 25
Jan 28, 2016 at 11:01 PM
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)
0