Thread: [Solved] Divide by zero error
View Single Post
 
Old 08-17-2016, 07:10 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
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
File Type: jpg Error.jpg (49.1 KB, 18 views)
Reply With Quote