Logic required

[shiveshsingh]

Hi guys

please help me in building below logic

I need last column

A	B	C	Result
Cat	10	1	10
Tiger	54	2	10 Divide by 2
Dog	56	3	(10 Divide by 2)/3
Rabbit	34	4	((10 Divide by 2)/3)/4
Pug Boss	43	5	(((10 Divide by 2)/3)/4)/5

Thanks

[suryaa30]

=(Result / Alt(above(Result),1))

[shiveshsingh]

Not working

[sunny_talwar · Accepted solution]

May be this

=If(RowNo() = 1, B, Above(Result)/C)

or this

=If(RowNo() = 1, B, Above(Column(1))/C)

[shiveshsingh]

Thanks Sunny, got my mistake. small bracket played all the game