IF false go to next cell and repeat (loop)

Hello I am new to this forum so I hope I do this correctly.

I am needing help with a problem. I am a novice at VBA so I am hoping to accomplish my task with a formula.

I need to track breaks and lunches at work for employee's. I want to know if there is a way to write an if statement that will go to the next cell if the statement returns false.

I basically want to have a blank page with a formula that will pull data from another page but only if the person worked that day.

so what I have is this

=IF([formula.xlsx]TimeQey!$A1="worked",[formula.xlsx]TimeQey!$B1)

But then I have a page full of false. How can I only return the data for cells where the value is worked?

I need something that says if value is 'false' or 'off' then skip and go to next cell


Thank you

Terri

Every IF has 3 parts.
1) An expression evaluating a True or False condition
2) What to do if the expression is TRUE
3) What to do if the expression is FALSE

=IF(condition, dothisifTRUE, dothisifFALSE)

The 3rd option is actually optional, but if it's omitted and the expression is FALSE, then the IF simply returns FALSE

You just need to tell the formula what to do if the expression is FALSE

=IF([formula.xlsx]TimeQey!$A1="worked",[formula.xlsx]TimeQey!$B1,"")

You're nearly there.

You can leave the cells blank where the value in cell A1 is not "worked" by slightly changing your formula:

Formula:

Please Login or Register  to view this content.

Excel is a constant learning process and it's great to help each other. If I've helped you today, a click on the star on the left is appreciated.

I am pulling back hundreds of employee's breaks. I don't want empty cells either. Is there a way for it to just skip that row if it is false?

Are you saying that
=IF([formula.xlsx]TimeQey!$A1="worked",[formula.xlsx]TimeQey!$B1)
If A1 does NOT = worked, then 'In the same formula' check A2, if that is worked, then return B2 ?

Try
=VLOOKUP("worked",[formula.xlsx]TimeQey!$A$1:$B$1000,2,0)