Running balance column formula not auto adjusting properly in row below when a row is inserted.

		Microsoft Office Forums > Microsoft Excel > Excel
Running balance column formula not auto adjusting properly in row below when a row is inserted.

FAQ

Thread Tools

Display Modes

11-08-2018, 02:32 PM

Marcia

Windows 7 32bit Running balance column formula not auto adjusting properly in row below when a row is inserted.

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

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))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keep balance column empty if no amount entered	baes10	Excel	3	08-14-2018 06:31 AM
Adjusting width of one column	cinci-hal	Word	5	03-08-2018 10:01 PM
Word 10 Tables: Column to auto number 1.1, 1.2 etc in sequential rows	FrauBaker12	Word Tables	7	06-24-2016 11:52 PM
Auto-adjusting Formula (by date)	ShankedS	Excel	2	12-03-2014 03:56 PM
Adjusting column widths	norwood	Word VBA	0	09-24-2013 06:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 AM.