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

Hello,
Thanks for your answer but I don’t get it :frowning:


How can I creat two formulas, one to calculate the increase in figures and the second in percent between each row ?

Thanks in advance.

@Thibaud_Donzier - currently it is not easy in Coda to do this . But there are posts that tell you how to go about it - Adding values from previous rows