Dealing with zero values
Closed
sphillips
-
Jun 15, 2009 at 02:58 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 15, 2009 at 08:39 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 15, 2009 at 08:39 PM
Related:
- Dealing with zero values
- Vba colorindex values - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- How to deal with a trojan virus ✓ - Viruses & Security Forum
- How to copy values from one sheet to another in excel - Guide
- Insert picture in Excel macro which takes the file name refrence - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 15, 2009 at 08:39 PM
Jun 15, 2009 at 08:39 PM
suppose A1 is blank and B1 is having some number and C1 has the formula
=B1/A1 will give that error
insstead in C1 type ths formula
=IF(A1=0,"",B1/A1)
after the first comma it is two double quotes.
=B1/A1 will give that error
insstead in C1 type ths formula
=IF(A1=0,"",B1/A1)
after the first comma it is two double quotes.