Subtracting row-1 data to get next value

[Ekta]

Dear All, 

I am stuck at this formula, appreciate if you can help me please.

The data is like below, i have 3 columns and column A is prepopulate. I need to populate column R and B and they are interrelated.

we will have one row data populated like here data with  40 and 444 but following rows need to be populated with the logic

like for row with A= 126, R = 3000-40 and B with a logic and so on

A	R	B
40	30000	40
126	3000-40	if [A]>[R] then [R] else [A] endif
444
5555
6666
444	50000	if [A]>[R] then [R] else [A] endif
555	50000-444
666

Thank you so much in advance

[Christina_H]

Those are the results my workflow above gives (with the initial R value for student 1 reset to 3000 rather than 30000), so I believe it's doing what you want it to.

[Ekta]

@atcodedog05 Thank you so much, works perfectly fine:)

[atcodedog05]

Happy to help : ) @Ekta 

Cheers and have a nice day!

[Hollingsworth]

Hi @Ekta,

I'm glad you were able to get assistance on this issue. In future though, please limit your tags to those which apply to your issue. This will improve the search results in the community and present your post more efficiently to those who are interested in those tags.

Thanks!

[Ekta]

@Hollingsworth Thank you so much, i will make sure to limit my tags.

Thank you!

[Ekta]

@Christina_H Thank you so much for the workflow:)