Find % change from last month automatically updated

		Microsoft Office Forums > Microsoft Excel > Excel
Find % change from last month automatically updated

04-03-2020, 02:50 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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

Generally there are 2 ways:
=IF(DividorFormula = 0, ExpressionWhen0, YourFormula)
=IFERROR(YourFormula,ExpressionWhen0)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 PM.