Previous Topic Next Topic

Excel: formula to choose if cell is correct

Closed
Karlo - Sep 27, 2010 at 06:50 PM
venkat1926 Posts 1863 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


Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses