#DIV-0! error Help with IF forrmula

[Scrumpywill]

Hello, could someone please help where and how I would place the IF formula to remove the #DIV-0! error

im using =(O18-H18)/ABS(H18) but there is on value in cell H18 so it returning an error

Many Thanks Steve

 

[Scrumpywill]

its worked but I was asked if the abs was needed - I would like to know

 

[Aladin Akyurek]

its worked but I was asked if the abs was needed - I would like to know

If you are not interested in the sign of the division, the abs is not needed. You can easily check the results with abs and without abs and determine which usage suits your requiremnts.

 

[Scrumpywill]

I would like to send you the spreadsheet to see if you think I need the abs or if there is a better way

 

[Aladin Akyurek]

I would like to send you the spreadsheet to see if you think I need the abs or if there is a better way

You can judge yourself whether:

(1)

=IF(ISNUMBER(1/H18),(O18-H18)/ABS(H18),"")

or (2)

=IF(ISNUMBER(1/H18),(O18-H18)/H18,"")

suits the best what you are after.