Check each cell to find values

[JohnsonFelix]

Hi,

I have values in column a1,b1,c1, I would need an if function in Cell D1.

Condition is, if I have values available C1 then it is highest priority, if C1 doesn't have any values or any error then it has to check b1, if B1 has values then b1 is second priority, if error, it has to check cell A1 and vice versa

Do I get if function for this conditions?

regards
Johnson

 

[Joe4]

OK, I think you misunderstood what I was suggesting.

Since A1:C1 can return errors, I am guessing that there are actually formulas (and not hard-coded values) in those cells. Am I right?
If so, update THOSE formulas with the IFERROR code.

So, whatever the current formula in cell A1 is, change it to this:
=IFERROR(original formula,"")

And then do the same for B1 and C1.

So then there would not be any errors in any of those cells, and my original formula I posted for you in my first reply should work.
Otherwise, if try to handle the errors in the other formula, it gets really messy and complex.