G
Guest
Hi,
The below formula
=IF(OR(G23<G$45,G23>G$46),"",IF(G$48>0,(G23-G$45)/G$47,(G$46-G23)/G$47))
is used to generate data. If there is only one data in the set, then it
returns a #VALUE! Error message (as expected)
The below formula is then used to show the absolute value of that answer in
another set of cells
=IF(N(CO23)=0,"",(ABS(CO23)))
The problem being, I do need the absolute value of the data from those
cells, but not the error code because it mucks/stops up other formula:
=MATCH(MAX(B52:AD52),B52:AD52,0)
Does anyone know of a way to get the second formula to change #VALUE! for an
empty cell, as the answer, when the #VALUE! error is generated, but transfer
all numbers (where there are any) in tact!??
Thanks in advance,
Ted.
The below formula
=IF(OR(G23<G$45,G23>G$46),"",IF(G$48>0,(G23-G$45)/G$47,(G$46-G23)/G$47))
is used to generate data. If there is only one data in the set, then it
returns a #VALUE! Error message (as expected)
The below formula is then used to show the absolute value of that answer in
another set of cells
=IF(N(CO23)=0,"",(ABS(CO23)))
The problem being, I do need the absolute value of the data from those
cells, but not the error code because it mucks/stops up other formula:
=MATCH(MAX(B52:AD52),B52:AD52,0)
Does anyone know of a way to get the second formula to change #VALUE! for an
empty cell, as the answer, when the #VALUE! error is generated, but transfer
all numbers (where there are any) in tact!??
Thanks in advance,
Ted.