Ask Your Question
0

IF formula question

asked 2017-06-04 23:43:40 +0200

appreciatethehelp gravatar image

Hello all.

Please see the example doc I have uploaded in order to supplement my question:

C:\fakepath\IF function for "active" column example.ods

I am in need of a formula that states that If a cell in the “ACTIVE?” column reads “YES”, then the adjacent time in the “TIME INVESTED DAILY” column is added to the “TOTAL TIME” column. Conversely, if the “ACTIVE?” column doesn't say “YES”, then the figure in the “TIME” column should not be added to the “TOTAL TIME” column.

I think that, To use cell D2 as a starting point, the formula needs to start with something along the lines of =IF(C2= "Yes", but am not sure where to go from there.

Thanks in advance.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-06-05 06:44:19 +0200

=IF(C2= "Yes",B2,"")

edit flag offensive delete link more
1

answered 2017-06-05 08:00:47 +0200

robleyd gravatar image

Is Total Time a running total of the values in D? If so, the attached file may do what you want, or at least point you in the right direction. I've used the UPPER function to test the value in C, so it can be Yes, YEs, yEs, etc. Note the formula in D2 is different from the rest of D to allow for no previous total.

ifquery.ods

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-04 23:43:40 +0200

Seen: 178 times

Last updated: Jun 05 '17