Thread: Zeros in text resulting in #div/0! even when using IF function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Zeros in text resulting in #div/0! even when using IF function
... appreciate an adjustment to get
this one right! =IF(D91=0,0,D71/D91).

Try this adjustment: =IF(D91+0=0,0,D71/D91)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote