please check this formula

  • Thread starter Thread starter keyur
  • Start date Start date
K

keyur

hi!

i have this formula in J6

=IF(ISBLANK(I6),0,IF(I6=I7,1,0))

and I6 is blank. this results in '1'. but i am aiming to
get '0'.

i m doing this to count how many duplicate results i have
in a list. i cant think of a better way. wht i want is
that first it should

check whether I6 is blank,
if blank
return '0'
if not
check whether I6=I7 (just n example!)
if equal
return '1'
if not
return '0'

can someone tell wht's wrong in this. i ve not used
ISBLANK before so maybe my syntax is wrong. it might be
just a little stupid error.

thanks
thanks
 
hi!

i found the error, actually i had a formula in the cell
which results in blank but i guess ISBLANK doesnt takes it
as blank.

now i can someone tell me if there's a way to do wht i
want without deleting the formula.

thanks.
 
is I6 completely without contents, or does it have some formula in it that
evaluates to ""?

If theres a formula there it might be more flexible to use
IF(I6="",0,IF(I6=I7,1,0))
 
Back
Top