Calculated Field Formula

Tubbs123

New Member
Joined
Oct 29, 2019
Messages
4
I have a calculated field formula calculating a simple division as follow:

='Cell C2' / 'Cell B2'

Some cells are returning the #DIV/0! error because some column C cells are zero. How do I write the formula to return a blank when the denominator is zero.

Thanks
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Tubbs123

New Member
Joined
Oct 29, 2019
Messages
4
Great Thanks Paul. What if I have the numerator and the denominator as a zero? in this instance its returned #NAME error

=IF(OR(b2=0,ISERROR(c2/b2),"",c2/b2) does not work
 

Watch MrExcel Video

Forum statistics

Threads
1,099,914
Messages
5,471,473
Members
406,764
Latest member
ExcelMaker007

This Week's Hot Topics

Top