Check if cells are blank or zero help please [Closed]

Report
Posts
2
Registration date
Friday May 29, 2015
Status
Member
Last seen
June 1, 2015
-
Posts
2
Registration date
Friday May 29, 2015
Status
Member
Last seen
June 1, 2015
-
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 reply

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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.
Posts
2
Registration date
Friday May 29, 2015
Status
Member
Last seen
June 1, 2015

Thank you very much Mazzaropi I will try that now.