Looking to make a forecast formula

Copper Contributor

Hello, I'm looking to make a basic change in value formula for interest on a credit card.

 

ex.

Jan = $136

Feb = 138

Mar = 124

 

I want the column to auto fill that my change in interest was $2 Jan. > Feb., and -$14 Feb. > Mar.

3 Replies

@tb_92 

For example:

S1210.png

The formula in C3 is =IF(B3="","",B3-B2)

This can be filled down as far as you want.

Hi, @Hans Vogelaar, I may need to be linked to a video or something, because it does not seem to be working for me.

tb_92_0-1647638345865.png

 

@tb_92 

It should be

 

=IF(K4="","",K4-K3)