Remove #DIV/0!

Solved/Closed
sam - 9 Jul 2012 à 03:56
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 Jul 2012 à 09:32
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

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
10 Jul 2012 à 10:39
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
Hi Trowa,
It's working, Thanks a lot.
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
12 Jul 2012 à 09:32
You're welcome.

Regards