Thread: [Solved] Divide by zero error
View Single Post
 
Old 08-16-2016, 08:42 AM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
  
Join Date: Jun 2012
Posts: 245
otuatail is on a distinguished road
Default
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.
Reply With Quote