abberyfarm
Well-known Member
- Joined
- Aug 14, 2011
- Messages
- 733
Hi here,
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
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 |