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.

If, and question
Yahoo mail forgot password and security question - Guide
Mom’s secret question - Guide
Google recovery password security question - Guide
Your account has been disabled. if you have any questions or concerns, you can visit our faq page here. - Facebook Forum
Upside down question mark on keyboard - Guide

1 response

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!

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.

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
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)

Similar discussions

Keyboard troubles

My account locked connect to gemail

My Fb Account is been disabled please help

How to unlock my File Safe in Huawei Y7

Forgot password for Private Safe

Similar discussions

Subscribe To Our Newsletter!