#### abberyfarm

##### Well-known Member

- Joined
- Aug 14, 2011

- Messages
- 733

I have two Columns, A and B. Column A contains numbers and Column B contains zeros. See below.

I need to insert 1's on certain rows on Column C based the condition below..

The condition is:

If there is a zero in Column B and the value in Column A is > 0 and <2.22, then insert a 1 three rows above in Column C and a 1 on the next row in Column C.

Thank you

Excel Workbook | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

1 | 2.00 | 1 | ||||

2 | 2.00 | |||||

3 | 0.44 | |||||

4 | 0.64 | 0 | Value in Col A is > 0 and | |||

5 | 0.67 | 1 | ||||

6 | 2.25 | |||||

7 | 1.67 | |||||

Sheet1 |