Thread: Find % change from last month automatically updated
View Single Post
 
Old 04-03-2020, 02:50 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Quote:
Originally Posted by GraemeSS View Post
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)
Reply With Quote