formula for if a cell reaches a certain value

[Lise]

Hi

I have a row of cells that autocalculate from the cells above - when one of
these cells reaches >=13 I want the next two cells going across to
automatically enter specific text but if not >=13 I want the cells to
continue with the autocalculation. Can this be done?

 

[T. Valko]

Can you be more specific?

If which cell is >=13?

Which cells do you want the specific text to appear in? What is the specific
text?

 

[Lise]

Sure

Say I have 10 cells across that autocalculate if any of those cells
calculate to >=13 i want the next two cells to say Compulsory Rest Day then
have the cells left continue auto calculating - might be too hard not sure

Thanks Biff
--
Thanks

Lise

Can you be more specific?

If which cell is >=13?

Which cells do you want the specific text to appear in? What is the specific
text?

 

[T. Valko]

Sorry, not following you. Maybe someone else will be able to see what I'm
not seeing.

--
Biff
Microsoft Excel MVP

Sure

Say I have 10 cells across that autocalculate if any of those cells
calculate to >=13 i want the next two cells to say Compulsory Rest Day
then
have the cells left continue auto calculating - might be too hard not sure

Thanks Biff

 

[Lise]

Sorry - trying to be clear - lets see

these cells have formula to sum the cells above them to give a total - see
second line

cell 1 - cell 2 - cell 3 - cell 4 - cell 5

11 12 13 so on and so on


When a cell reaches 13 or higher i want the next two cells to show autotext
but then start autocalculating again so .....

cell 1 - cell 2 - cell 3 - cell 4 - cell 5 - cell 6 - cell 7

11 12 13 REST REST 1 2

Hope this helps - can't think of another way of describing - thanks for your
patience

 

[T. Valko]

Rhetorical question:

Why are posters so reluctant to tell us where their data is located?

Ok, it looks like you want a sequential count.

My best guess is something like this:

=IF(OR(MOD(COUNTA($A1:A1),15)={14,0}),"Rest",MOD(COUNTA($A1:A1),15))

Copied across