Check if cells are blank or zero help please

Closed
angieanguk Posts 2 Registration date Friday May 29, 2015 Status Member Last seen June 1, 2015 - May 29, 2015 at 11:14 AM
angieanguk Posts 2 Registration date Friday May 29, 2015 Status Member Last seen June 1, 2015 - Jun 1, 2015 at 04:18 AM
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which will check if cell A2 and/or cell B2 is blank or contains a Zero) if either cell is blank or contains a zero then cell C2 needs to show a zero.

I then need to total column A divided by column B as long as the values in these are not blank or zero.

Any help would be greatly appreciated.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 30, 2015 at 09:10 AM
angieanguk, Good morning.

This formula does what you want.
C2 --> =IF(OR(A2<=" ",B2<=" "),0,"")
Of course there are others ways to do the same thing.

If you want to avoid to have full zero in column B and the division to error, just use the IFERROR function.

Suppose the total is at C11.
C11 --> =IFERROR(A11/B11,"")

Is this what you want?
I hope it helps.
angieanguk Posts 2 Registration date Friday May 29, 2015 Status Member Last seen June 1, 2015
Jun 1, 2015 at 04:18 AM
Thank you very much Mazzaropi I will try that now.
0