redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,575
- Office Version
-
- 365
- Platform
-
- Windows
Hello all
Can anyone suggest how to add an IF(ISERROR function into my line of code below that will show a zero instead of a #DIV/0 error
thanks in advance
Can anyone suggest how to add an IF(ISERROR function into my line of code below that will show a zero instead of a #DIV/0 error
Code:
.Range("L" & NextRow).Formula = "=SUM(L2:L" & NextRow - 1 & ")/('Report data'!$D$3-(COUNTIF(L2:L" & NextRow - 1 & ",""NA"")))"
thanks in advance