fill cells with yes if a value is true

[Iain Clarendon]

I have a spreadsheet with week 1, week 2 across columns for 1 year.
In a row I have the frequency drop down 1w (which = 7 days), 2w (which = 14 days)
I would like to return "yes" in the cells below week 1 if the frequency = 1w. Same with select 2w and every second week the cell returns "yes"

[skywriter]

Same with select 2w and every second week the cell returns "yes"

What do you mean every second week. You mean every even numbered week?

[FDibbins]

Hi, welcome to the forum

Not sure where you want to put this, but it sounds like you want something like =IF(C5="","","Yes")

[skywriter]

I'm going to assume what you mean is the first week is a yes no matter what and if frequency is 1W then everything is a yes after that.
If 2W, then week1 is a yes then 3, 5, 7 etc.

[Iain Clarendon]

Hi Skywriter,

Not sure if this is how I reply to you,
Yes that is what I was after.
What would you change to include other changes like 3W, 4W, 12W etc.
I am doing this so I can add 4 week and 12 week checks for reminder to complete jobs on my aquaponics set up.

[samba_ravi]

see the attached file, one column was created for Starting week of the tank cleaning

[Iain Clarendon]

Good evening nflsales,

Thanks for the update, this works well until you select 12W, it seems to be only picking up the first digit in 12 so fills like it is 1. You can see this also if you add 26W, so picks up the two and fills every second cell?

Cheers Iain

[samba_ravi]

E5=IF(AND($C5<=E$2,MOD(E$2-$C5,SUBSTITUTE($D5,"W","")+0)=0),"Yes","")
Then try the above formula and copy across

[Iain Clarendon]

THANK YOU,

Much appreciated

Cheers Iain