Creating an excel formula

Copper Contributor

I need help with creating a formula that subtracts different values from the first original value, how can I link it to an entire column so that the formula is only subtracting from the first value rather switching up to the next one?

1 Reply

Hi @Sal97 

 

You can achieve it by freezing the first cell value and then subtracting other values from it.

You can freeze any cell by placing $ sign in it, for example if you want to freeze cell A1 make it like $A$1.

 

A sample file is also attached for your reference.

 

Thanks

Tauqeer