How to use IFERROR, ROUND and SUM in one formula
What is the IFERROR function?:
The IFERROR function is designed to manage errors in formulas and calculations.
IFERROR checks a formula, and if it evaluates to an error, returns another value you specify; otherwise, returns the result of the formula.
The syntax of the Excel IFERROR function is as follows:
IFERROR(value, value_if_error)
- Value (required) - what to check for errors. It can be a formula, expression, value, or cell reference.
- Value_if_error (required) - what to return if an error is found. It can be an empty string (blank cell), text message, numeric value, another formula or calculation.
Solution:
Try
=IFERROR(ROUND(SUM(D7+N7)/U7,2)),"")
if you want the cell to be blank, or
=IFERROR(ROUND(SUM(D7+N7)/U7,2)),0)
for the cell to show zero.
Obtained from the OzGrid Help Forum.
Solution provided by KjBox.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use Formula: =IF ERROR |
| How to use IFERROR - example provided |
| How to round to nearest .25 (times) |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
