Excel: formula to choose if cell is correct

Closed
Karlo - Sep 27, 2010 at 06:50 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 27, 2010 at 09:48 PM
Hello,


Anyone know what the formula is to return the value of the cell with no error.

e.g. formula returns two results in cells A1 and A2


A1 is ############
A2 is 1.5 <--(this being the correct result)


A3 will then return the result of the non-error which is 1.5


Thanks,
Karlo


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 27, 2010 at 09:48 PM
if A1 is having only Hash (#) signs that doe not mean this is error. It means the length of the value is going beyond the cell border. try to increasing cell length

if error it will be something like these
#N/A
#DIV/0!
N/A
ETC.

examine the sheet.
0