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
angieanguk Posts 2 Registration date Friday May 29, 2015 Status Member Last seen June 1, 2015 - Jun 1, 2015 at 04:18 AM
Related:
- If cell is zero then blank
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Excel if cell color is red then - Guide
1 reply
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 30, 2015 at 09:10 AM
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.
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.
Jun 1, 2015 at 04:18 AM