Hi, I'm currently trying to get to grips with excel and have a quick question. Sorry if this is a basic excel question but I am currently using a formula that requires the addition of a number of cells such as =1/C4 + 1/D4 + 1/E4, but I've found that when D4 for example is blank the answer is coming out as an error, is there any way to tell excel to discard these cells if they are blank, so instead it would just work out, in the aboove example, if D4 was blank, =1/C4 + 1/E4?
Thanks in advance, Conor
Excel question about how to discard any info in empty cells
Hi Peter cheers for the response, something is still wrong, the error I'm getting is #DIV/0! which is down to the equation being 1/c4 where c4 is 0, what would you recommend. Also I had simplified that previous equation that I posted initially about, if for example it actually was something like =1/d5 + 1/f8 + 1/h3 etc.. and basically it was more random so I couldn't use the sum(d4:d7) - could I still do:
=IFERROR(SUM(D5+F8+h3),"")
where I've simplified 1/f8 down to simply f8 on one of the other sheets?
Sorry if this is a confusing post.
Thanks again for your help.
Conor
=IFERROR(SUM(D5+F8+h3),"")
where I've simplified 1/f8 down to simply f8 on one of the other sheets?
Sorry if this is a confusing post.
Thanks again for your help.
Conor
Hi, can nobody help, I wan to add up a number of cells but don't want to include any that =0 as if any do I get the error #DIV/0! The formula I'm writing in the cell is similar to =1/c4+1/d4+1/e4 but if in this example if any of c4, d4 or e4 =0 I'm getting an error, does anyone know how I can fix this?
Thanks
Thanks
It might be easier if you just check to see if the cell is empty or not, if not, do the division, if empty, leave blank.
The non empty cells can then just be added up to give the desired result.
On the attached if you delete any number in col C, F4 will give a Div error, D7 will still be ok.
Are you using the multple spreadsheet or just the single?
The non empty cells can then just be added up to give the desired result.
On the attached if you delete any number in col C, F4 will give a Div error, D7 will still be ok.
Are you using the multple spreadsheet or just the single?
You do not have the required permissions to view the files attached to this post.