View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Machineman Machineman is offline
external usenet poster
 
Posts: 3
Default IF function Question

Hello,

I have a formula in a column that determines when a machine should be
turning on and off based on data from another column. When the criteria is
met, the formula writes the word "Start" in the cell. How do I write a
formula in the next column over so that if the word "Start" shows up in
Column 2, I want the next 5 rows down in Column 3 to have the word "Start"
too.

For example:
Column1 Column2 Column3
1 Start Start
2 Start
3 Start
4 Start
5 Start
6 etc......
7