excel - Check two columns for numbers and output the number found into the third column -
i'm looking equation check 2 cells side side , output 1 contain numbers third column. example:
abc 123 = 123 def 789 = 789 456 lmn = 456
assuming data in columns , b:
=if(isnumber(a1),a1,if(isnumber(b1),b1,"no numbers found"))
the formula display "no numbers found" if neither contain number.
edit:
if numbers not formatted numbers, try instead:
=if(not(iserror(int(a1))),a1,if(not(iserror(int(b1))),b1,"no numbers found"))
Comments
Post a Comment