Microsoft Office Forums - View Single Post - [Solved] Divide by zero error

Thread: [Solved] Divide by zero error

View Single Post

Old

08-16-2016, 01:34 AM

otuatail

otuatail is offline

otuatail uses Windows 7 64bit

Windows 7 64bit otuatail uses Office 2007

otuatail uses Office 2007

Office 2007

Competent Performer

The original poster

Join Date: Jun 2012

Posts: 245

otuatail is on a distinguished road

Default

Divide by zero error

I have a cell with a divide by zero error.

I have conditional formatting for error

"=IFERROR(SUM((A3+$K$2)/(B3-2)),"")"

This cell should be blank. I also want the cell blank if the value turns negative.

Reply With Quote