Morning All,
I am using a simple divide forumla (E5/F5) in cell (H5) to return an average. Is there anyway that if the contents of E5 and F5 are zero that a blank cell or zero can be returned instead of DIV/0!.
Regards,
Matt
Morning All,
I am using a simple divide forumla (E5/F5) in cell (H5) to return an average. Is there anyway that if the contents of E5 and F5 are zero that a blank cell or zero can be returned instead of DIV/0!.
Regards,
Matt
=IF(ISERROR(E5/F5),"",E5/F5)
or to give you exactly waht you asked for:
=IF(OR(E5=0,F5=0),"",E5/F5)
Note that only a zero/blank in F5 will give a #DIV/0 error, a 0 in E5 will not.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Use =IF(Error.Type(E5/F5)=2,"",E5/F5)
Note the use of the Error.Type function within the formula. By using this, you are checking for errors causing the Divide by Zero, rather than just masking all errors when using ISError.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
