Thread: [Solved] Divide by zero error
View Single Post
 
Old 08-16-2016, 10:58 PM
c991257 c991257 is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default
=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.
Reply With Quote