Finding a cell depending on whether another cell is odd/even? I'm lost

  • Thread starter Thread starter DrSues02
  • Start date Start date
D

DrSues02

Thank you so much. The formula is finally working.

I had to change it t
=INDEX(Summary!A:A,B16-(IF(MOD(B16,2)=1,-1,1)))...basically, I jus
changed it to a MINUS sign, because that returned the correc
opponent.

However, is there a way to return a blank space instead of N/A when i
cannot find the team name on the Summary sheet?

Not every team is wasted, so it would be better if it just left a blan
space there instead of the N/A.

Any suggestions?

DrSues0
 
To get rid of these sorts of error messages, you use this general approach:

=IF(ISERROR(XXXX),"",<your original formula goes here>)

In place of the XXX I show above, you would put in the part of the formula
that could produce an error. Example =A1/B1 gives a DIV/0 error if B1 = 0, B1
is blank, or B1 contains text, so you write it as

=IF(ISERROR(A1/B1),"",A1/B1)
 
Back
Top