Find % change from last month automatically updated

p45cal · #7 04-03-2020, 02:13 AM

Quote:

Originally Posted by GraemeSS

Problem is when I have formulas looking for data from the other sheets it assumes the next column has zero and I get a Div/0 error. How do I get the formula to remove the zero if there is no data?

I've not understood - could you attach a little spreadsheet with a few rows of data and as many sheets as necessary and few rows, some showing the formula (which formula?) working properly, some with the division by zero error?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LINK field path will be updated automatically	bynkook	Word	1	02-28-2020 02:54 AM
change formula based upon change of month	invgrp2	Excel	7	05-03-2018 10:46 AM
How to get data updated automatically without show this message?	LearnerExcel	Excel Programming	2	02-12-2018 08:20 PM
Can i automatically add a debit on the first of every month?	Taras49	Excel	2	06-16-2015 12:54 PM
How can references be updated automatically?	ezthelm	Word	2	05-30-2011 03:45 AM