Previous Topic Next Topic

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

Answer 1 / 1
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.
0
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

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
change cell by clicking on another cell
Sedicee -
TrowaD -

5 responses
Change color to different cells based on another cells text.
Riggs2015 -
Riggs2015 -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses
Excel VBA copy and paste loop with logic condition
Yogibearv -
Yogibearv -

6 responses