Problem with #VALUE/0! error
 

(this may be a repeat question because my computer went funny - but here you
a)

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.

Problem with #VALUE/0! error
 

sorry, its this formula that causes the error value:

=IF(OR(G23<G$45,G23G$46),"",IF(G$480,(G23-G$45)/G$47,(G$46-G23)/G$47))

the other one is what displays its absolute value (even if that value is an
error message - how can I make it display a blank cell rather than the
error!?)

thanks.
Ted.

"Ted" wrote:

(this may be a repeat question because my computer went funny - but here you
a)

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.

Problem with #VALUE/0! error
 

THIS THREAD IS NO LONGER BEING USED - THE PROBLEM CHANGED TOO MUCH.

Ted.

"Ted" wrote:

sorry, its this formula that causes the error value:

=IF(OR(G23<G$45,G23G$46),"",IF(G$480,(G23-G$45)/G$47,(G$46-G23)/G$47))

the other one is what displays its absolute value (even if that value is an
error message - how can I make it display a blank cell rather than the
error!?)

thanks.
Ted.

"Ted" wrote:

(this may be a repeat question because my computer went funny - but here you
a)

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.