Need help in Excel Formula

[rival36]

I want following condition to be satisfied in attached 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.

Please help

 

[snjpverma]

Enter formula in B6 and Copy down.

Book1
	A	B	C
5	54		2
6	1	54	0
7	545	54	0
8	45	54	0
9	5	54	1
10	78	5	2
11	80	78	0
12	4	78	0
13	87	78	4
14	5	87	0
15	4	87	6
Sheet1

Cell Formulas
Range	Formula
B6:B15	B6	=IF(C5,A5,B5)

 

[rival36]

Oh God, is it for real?? was it so simple?? Can't Believe that!
Thanks a Lot Sir.... Saved my lot of time.. It Worked Perfectly..
Appreciated... Keep the good work going..

 

[snjpverma]

Glad it worked as expected for you. Thanks for the feedback.