Microsoft Office Forums - View Single Post - [Solved] Running balance column formula not auto adjusting properly in row below when a row is inserted.

Thread: [Solved] Running balance column formula not auto adjusting properly in row below when a row is inserted.

View Single Post

Old

11-08-2018, 02:32 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2007

Marcia uses Office 2007

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Glad to be of help. This forum is full of very nice and very helpful people. You could shorten the formula a bit.
=IF(AND(C4="",D4=""),"",SUM($C$4:$C4)-SUM($D$4:$D4))

Reply With Quote