Forum Discussion
Solved
Help with replacing #DIV/0! error with text
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...
John,
=IFERROR(IF(H4<>"",(H4-G4)/G4,""),"N/A")
or
=IF(G4=0,"N/A", IF(H4<>"",(H4-G4)/G4,""))
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.
thanks
I would like a formula that returns 0% when both columns are zero, 100% when realized when target =0
| YR2 (2019) | ||
| Target | Actual | % - Deviation |
| 78.00 | 595.00 | ▲ 663% |
| 0.00 | 0.00 | 0% |
| 0.00 | 456.00 | 100% |
| 0.00 | 105.00 | 100% |
| 78.00 | 34.00 | ▼ -56% |
| 0.00 | 0.00 | 0% |