Dealing with zero values
Closed
sphillips
-
Jun 15, 2009 at 02:58 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 15, 2009 at 08:39 PM
venkat1926 Posts 1864 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
- Based on the values in cells b77 b81 ✓ - Excel Forum
- To highlight a cell with duplicate values in an excel, what conditions can be used? ✓ - Excel Forum
- Two values to find on the same cell ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Find values based on colum and sum in a table - Office Software Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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.
