Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
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? -- Thanks Lise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
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? -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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? -- Thanks Lise |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
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 "T. Valko" wrote: 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? -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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? -- Thanks Lise |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
Sorry, not following you. Maybe someone else will be able to see what I'm
not seeing. -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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 "T. Valko" wrote: 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? -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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? -- Thanks Lise |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
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 -- Thanks Lise "T. Valko" wrote: Sorry, not following you. Maybe someone else will be able to see what I'm not seeing. -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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 "T. Valko" wrote: 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? -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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? -- Thanks Lise |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for if a cell reaches a certain value
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(C OUNTA($A1:A1),15)) Copied across -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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 -- Thanks Lise "T. Valko" wrote: Sorry, not following you. Maybe someone else will be able to see what I'm not seeing. -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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 "T. Valko" wrote: 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? -- Biff Microsoft Excel MVP "Lise" wrote in message ... 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? -- Thanks Lise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticall e-mail me when cell value reaches a value | Excel Worksheet Functions | |||
Is there a way to make a time cell not reset when it reaches 24? | Excel Discussion (Misc queries) | |||
Highlight Cell when value reaches every interval of 500 | Excel Discussion (Misc queries) | |||
execute external program when cell reaches certain value | Excel Worksheet Functions | |||
HELP ME !! PLEASE!! How do I highlight a cell when it reaches a va | Excel Worksheet Functions |