Calculating Percent Change

Hi,

I am trying to calculate the percent change between two numbers in the same column, just different rows. If I were doing it in Excel, it would be =(B9-B3)/B3 but I can’t seem to find the way to make this formula work in Coda. Is it possible?

Thanks in advance for your help !

If it’s just specific rows, you can reference them directly with @. See:
image

Otherwise, if you’re looking for a more general form, this post has several methods:

1 Like

Dear @Dalmo_Mendonca,

With respect for your input, you’re showing again that it’s as simple as that to take any cell by using "@ " . “column name”, and make the calculations as desired.

@mallika - another suggestion to add to the templates :thought_balloon:

1 Like