View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jvega jvega is offline
external usenet poster
 
Posts: 7
Default Dividing by zero

Dave,
Awesome, thanks for your help, it works now

Regards,
Josh

"Dave" wrote:

Sorry, that should be:
=IF(AND(I19=0,K19=0),0,IF(I19=0,-0.15,MAX(MIN(((I19-K19)/I19),0.15),-0.15)))

"Dave" wrote:

Hi,
Try:
=IF(AND(I19=0,K19=0),0,IF(I19=0,0.15,MAX(MIN(((I19-K19)/I19),0.15),-0.15)))

Regards - Dave.