G
Guest
(this may be a repeat question because my computer went funny - but here you
are
The below formula
=IF(N(CO23)=0,"",(ABS(CO23)))
it to return an absoulte value from some data. if there is only one data in
the set, then it returns a #Value! error sign. Is there a way to get it to
put a blank in the intended cells when this happens, rather than the error as
other formula gets mucked up by it!
the other formula is:
=MATCH(MAX(B52:AD52),B52:AD52,0)
Has anyone any ideas please??
Ted.
are
The below formula
=IF(N(CO23)=0,"",(ABS(CO23)))
it to return an absoulte value from some data. if there is only one data in
the set, then it returns a #Value! error sign. Is there a way to get it to
put a blank in the intended cells when this happens, rather than the error as
other formula gets mucked up by it!
the other formula is:
=MATCH(MAX(B52:AD52),B52:AD52,0)
Has anyone any ideas please??
Ted.