Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
=If(RowNo() = 1, B, Above(Result)/C)
or this
=If(RowNo() = 1, B, Above(Column(1))/C)
=(Result / Alt(above(Result),1))
Not working
May be this
=If(RowNo() = 1, B, Above(Result)/C)
or this
=If(RowNo() = 1, B, Above(Column(1))/C)
Thanks Sunny, got my mistake. small bracket played all the game