Excel: formula to choose if cell is correct

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.