• 408K Members
• 8,330 Online
• 464K Conversations

New Contributor

# IF Statement Help

I have this formula and need to change "BU2" cell to every six cell going forward.
Example Month 1
=IF(COUNTBLANK('Prelims & Lien Waivers Revised'!BU2),"Missing Monthly Paper Work","Payment Released")
Example Month 2
=IF(COUNTBLANK('Prelims & Lien Waivers Revised'!CA2),"Missing Monthly Paper Work","Payment Released")

Is there a way I can make this formula to capture every sixth cell instead of changing this manually?

3 Replies

# Re: IF Statement Help

Maybe this...

If you are copying the formula across the columns...

=IF(COUNTBLANK(OFFSET('Prelims & Lien Waivers Revised'!\$BU2,,(COLUMNS(\$BU2:BU2)-1)*6)),"Missing Monthly Paper Work","Payment Released")

If you are copying the formula down the rows...

=IF(COUNTBLANK(OFFSET('Prelims & Lien Waivers Revised'!BU\$2,,(ROWS(BU\$2:BU2)-1)*6)),"Missing Monthly Paper Work","Payment Released")

# Re: IF Statement Help

What happens if I am using this formula on a worksheets in the workbook looking at another worksheets?

Example: Payment Status worksheet looking at cell on Prelims & Lien Waiver worksheet

The only thing change is the cell on the Prelims & Lien Waiver worksheet and not Payment Status worksheet

Chen

# Re: IF Statement Help

It doesn't matter on which sheet you use that formula, the formula will always refer to the cells in the 'Prelims & Lien Waivers Revised' Sheet

Assuming you are copying down that formula down the rows...

So in the first formula cell, the formula will refer to the cell 'Prelims & Lien Waivers Revised'!\$BU\$2

and the next cell down the row, it will refer to the cell 'Prelims & Lien Waivers Revised'!\$CA\$2

and so on so forth.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies