Previous Topic Next Topic

Remove #DIV/0!

Solved/Closed
sam - Jul 9, 2012 at 03:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 12, 2012 at 09:32 AM
Hello,

I have below formula in a database and when "F" column is 0 it shows above. is there any ways that i can set this formula without appearing above

=IF(F4=10,(H4+(H5/F4)),H4+(H5/F4))/121*35

Thank and pls help
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Jul 10, 2012 at 10:39 AM
Hi Sam,

Try the following:
=IF(ISERROR(IF(F4=10,(H4+(H5/F4)),H4+(H5/F4))/121*35),"",IF(F4=10,(H4+(H5/F4)),H4+(H5/F4))/121*35)

Best regards,
Trowa
Sam
Jul 11, 2012 at 06:37 AM
Hi Trowa,
It's working, Thanks a lot.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Jul 12, 2012 at 09:32 AM
You're welcome.

Regards

Similar discussions

,">"&0),"") at the end of a countif formula
jutulu -
toony -

4 responses
Diskette Drive 0 seek failure (error message)
azajewel -
TechIlliterate -

133 responses
Ig stories from close friends to public
Darren -
zara -

31 responses
Undo remove link
Sam -
Abhishek0025 -

1 response