Remove #DIV/0!
Solved/Closed
sam
-
Jul 9, 2012 at 03:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 12, 2012 at 09:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 12, 2012 at 09:32 AM
Related:
- Remove #DIV/0!
- //192.168.l.0 - Guide
- Ubuntu remove password - Guide
- Remove recent files windows 11 - Guide
- Make div transparent - Guide
- How to remove number from blacklist - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 10, 2012 at 10:39 AM
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
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
Jul 11, 2012 at 06:37 AM
It's working, Thanks a lot.
Jul 12, 2012 at 09:32 AM
Regards