Please help me in this, I want a conditional formula to satisfy this condition in attached Excel Sheet image.
If C5 is greater than zero Put B6=A5, Otherwise Return B6= Value in Cell A Whenever Cell C has number greater than Zero Previously.
If C5 is greater than zero Put B6=A5, Otherwise Return B6= Value in Cell A Whenever Cell C has number greater than Zero Previously.
Want This Result | ||||||||
A | B | C | A | B | C | |||
54 | 1 | 54 | 2 | |||||
1 | 0 | 1 | 54 | 0 | ||||
545 | 0 | 545 | 54 | 0 | ||||
45 | 0 | 45 | 54 | 0 | ||||
5 | 1 | 5 | 54 | 1 | ||||
78 | 2 | 78 | 5 | 2 | ||||
80 | 0 | 80 | 78 | 0 | ||||
4 | 0 | 4 | 78 | 0 | ||||
87 | 1 | 87 | 78 | 4 | ||||
5 | 0 | 5 | 87 | 0 | ||||
4 | 1 | 4 | 87 | 6 | ||||