IFERROR, ROUND and SUM together

    Hi Folks


    =ROUND(SUM(D7+N7)/U7,2) works perfectly well until it reaches a row where no data has been entered yet when I get a #DIV/0! error of course.


    I'm trying to add in the IFERROR function without success: =IFERROR(ROUND(SUM(D7+N7)/U7,2))) as I keep getting a too few arguments error.


    Can anyone please advise where I'm going wrong please??


    Kind regards


    DezB

    Re: IFERROR, ROUND and SUM together


    The argument that is missing is what should be displayed if there is a error,


    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.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: IFERROR, ROUND and SUM together


    Hi KjBox


    Thank you that, most useful and appreciated.


    I've been "playing as well and came up with: =IF(D7+N7=0,"",ROUND((D7+N7)/U7,2)) which seems to do the job as well, what do you think?


    Kind regards


    DezB

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login