Looking up values from two different rows of the same column

[Eera_Pendharkar]

I need to use the values in the first and second row of the column 'pipe ID' to calculate value for another column.

The corresponding formula used in the spreadsheet is

=IF(K17="","",K16/K17)

How can I perform the same operation in appsheet?

[Marc_Dillon]

https://help.appsheet.com/en/articles/2355953-if

https://help.appsheet.com/en/articles/2357309-lookup