iserror

[Guest]

I am using LOOKUP to obtain values from another sheet, this formula is
replicate 3 times. In most cases at least one of the three formulas will
return #N/A, which is correct. I then want to add the result of these three
answers, but the #N/A doesn't allow. I found a thread in this forum regarding
ISERROR and attempted to use it in my formula, but it still returns #N/A.
Any assistance would be appreciated. Here's my formula:
=IF(ISERROR(LOOKUP(D16,'Point Scale'!$G$4:$G$33,'Point
Scale'!$H$4:$H$33))*(B14/60),"",(LOOKUP(D16,'Point Scale'!$G$4:$G$33,'Point
Scale'!$H$4:$H$33)))

 

[Pete_UK]

I'm not sure why you have the term

*(B14/60)

in the middle, as it isn't used in the later part of the formula. As
this is outside the ISERROR( ) function, then you may still get errors
if for example B16 contains text, as you are trying to divide 60 into
it. Try the formula without this term.

Hope this helps.

Pete

 

[Pete_UK]

Sorry, I meant B14 in the narrative, not B16.

Pete

 

[Guest]

Looks like you just need some additional parenthesis. Try this:

=IF(ISERROR((LOOKUP(D16,'Point Scale'!$G$4:$G$33,'Point
Scale'!$H$4:$H$33))*(B14/60)),"",LOOKUP(D16,'Point Scale'!$G$4:$G$33,'Point
Scale'!$H$4:$H$33))

You were taking the results of the ISERROR function (TRUE/FALSE) and
multiplying that by (B14/60). Now the (B14/60) is evaluated in the ISERROR
function.

HTH,
Elkar

 

[Guest]

Eklar, thanks for your help. When I enter your corrections it took care of
the #N/A error message and the cell is now blank, but I had to replace the ""
with a ZERO to get the results to add together. I think because the "" is
viewed as a text string and cannot be added. Anyway we got the problem
resolved. I've been struggling with this for hours and as soon as I found
this forum my problem was resolved within minutes. Have a great weekend!