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.

Why don't you say =IF(calculation>0;calculation;"")?

/Møller

Try
=or(iserror((A3+$K$2)/(B3-2)),((A3+$K$2)/(B3-2))<0)

as CF ( the SUM function you used is redundant)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

outatail. Conditional formatting cannot control the value of a cell. If you want it to be blank then the formula in the cell must return the value "".

Conditional formatting to control the color of the cell, borders and contents based on the value of a cell.

Well

=IF(($A3+$K$2)/($B3-2))>0;SUM(($A3+$K$2)/($B3-2));"")

Does retturn "" don't it

Also

=or(iserror((A3+$K$2)/(B3-2)),((A3+$K$2)/(B3-2))<0)
Dosn't do anything in conditional formatting. I want blank cells if less than zero or divide by zero error.

What do you mean? Perhaps add a sample sheet ( no pics pse)

By blank cell do you mean an empty cell or looking empty?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

G3 is negative so I want it BLANK

F3 -s Divide by zero error so I want it BLANK

SIMPLE as that.

Attached Files

Temp.xlsx (41.6 KB, 16 views)

Then you will need VBA

And you could be a little more courteous to people trying to help.

Cheers

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

=IF(OR($B3-1<=0;$A3+K$2<0);"";($A3+K$2)/($B3-1)) does what you need and you don't need conditional formatting.

I put this into cell G3 and I got an error

=IF(OR($B3-3<=0;$A3+K$2<0);"";($A3+K$2)/($B3-3))

I assume that "You don't need conditional formatting means paste it into the cell directly.

Attached error

Attached Images

Error.jpg (49.1 KB, 16 views)

Change the semicolons to commas.

Conditional formatting is a feature in excel.

Attached Images

2.jpg (46.1 KB, 14 views)

Thanks

I have used conditional formatting but that wouldn't solve this problem.

Then it would probably have helped if you didn't start saying that you have that.