Mar 27 2018
- last edited on
Jul 25 2018
Good morning all
I am currently working on a spreadsheet to show trends in relation to various incidents I deal with at work. I am looking to track changes in the number of incidents along with the percentage increase/decrease on a weekly basis but have come across a #DIV/0! error that I cannot solve (self taught newbie to excel).
The formula currently used to work out the percentage change from the previous week is
=IF(H4<>"",(H4-G4)/G4,"") and I am fully aware that the error is being caused because G4=0. I would like the cell to show some text such as "N/A" instead of the #DIV/0! error but am struggling to find the solution even with the help of Google! I have attached an example of the spreadsheet if that will help.
Any assistance is appreciated
Mar 27 2018 03:29 AM
Hi Sergei, thank's for the quick response
sorry but I'm a complete beginner with excel. Could you show me how to change my current formula =IF(H4<>"",(H4-G4)/G4,"") to use =IFERROR as you have described as I keep getting errors such as 'too many arguments for this function.
Mar 27 2018 03:39 AMSolution
Mar 27 2018 03:46 AM
Sergei you are a genius. I have been trying to solve this for two days! Thank you very much for your help.
Dec 08 2022 01:40 AM
I would like a formula that returns 0% when both columns are zero, 100% when realized when target =0
|Target||Actual||% - Deviation|