ISERROR question

[Canes70]

How can i get ISERROR to work with this formula?

=IF($AK$165="yes",((AF69/Y69)+(AG69/Y69)+(((AH69/$AH$23)*AJ69)/Y69)),(AF69/Y69)+(AG69/Y69)+(((AH69/AH$146)*AJ69)/Y69))

 

[Yahya]

try this
=IF($AK$165="","",IF($AK$165="yes",((AF69/Y69)+(AG69/Y69)+(((AH69/$AH$23)*AJ69)/Y69)),(AF69/Y69)+(AG69/Y69)+(((AH69/AH$146)*AJ69)/Y69)))

 

[Canes70]

No that didn't work. I'm still getting #div/0!. I'm trying to avoid that error

 

[Jonmo1]

Sometimes it's easier to test for what causes the error, rather then the error itself..

In this case, deviding by 0 causes the error.
You have 3 cells in that formula that would cause the error if they are blank or 0.

Also, your structure can be slightly improved since both the True and False results are exactly the same Except AH23 for True, AH146 for False

Try

=IF(OR(Y69=0,$AH$23=0,$AH$146=0),"",(AF69/Y69)+(AG69/Y69)+(((AH69/IF($AK$165="yes",$AH$23,AH$146))*AJ69)/Y69))

Hope that helps.

 

[Canes70]

It looks like that worked.

Thanks for the help