LinkBack URL
About LinkBackstry
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
"carl" wrote:
> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance
try
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
"carl" wrote:
> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks