Specific Text after 5 Cells in a column

[luckysoni.edu]

Dear All,

May you please help me getting the formula to put specific text in a cell after every 5 cells in a column

 

[ETAF]

you could do a couple of ways

in row 6
=IF(MOD(D6,5)=0,"bingo","")
and
=IF(MOD(H6,7)=0,"bingo","")

A spreadsheet attached would help here ,

What version of excel are you using -show version as solutions will be dependant on what version you have and therefore what functions available

 

[ArmstrongArcade]

Our internet went down at work for a bit, I only played around with the 5th row returns. Plagiarized--I mean, used ETAF's wb as a template.