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]

Welcome to the Board!

You can nest IF functions, like this:

=IF(C1<>"","C1 has value",IF(B1<>"","B1 has value",IF(A1<>"","A1 has value","all cells empty")))

Just replace the "... has value" parts with whatever you want to happen there.

 

[JohnsonFelix]

=if(c1<>"",c1,if(iserror(c1),if(b1<>"",b1,if(iserror(b1),a1,""))))

 

[JohnsonFelix]

Hi, But if have any error in cell c1 (#NA NA) then it has to pickup next cell b1

 

[Joe4]

What are the possibilities of entries in cells A1:C1?
Are there ever blanks, or is it just errors and values?

 

[JohnsonFelix]

I will have blanks, errors and values as well

 

[Joe4]

Are they formulas in cells A1:C1?
If so, can we amend those formulas to get rid of the errors, and replace them with blanks, like this?
=IFERROR(original formula,"")

If you can do that, then my original formula would work.

I typically find it easier to handle with errors at their source, instead of trying to account for them done the line, if that is an acceptable method for you.

 

[JohnsonFelix]

Yes, But I am getting error, " You have entered incorrect functions"

 

[Joe4]

What version of Excel are you using?
IFERROR was introduced in Excel 2007.

If you have an older version, you would need to use a different format, i.e.
=IF(ISERROR(original formula),"",original formula)

If you are using a version of Excel that is 2007 or newer, and are getting errors, please post your formula here so we can see how you are setting it up.

 

[JohnsonFelix]

=IFERROR(C1<>"",C1,IFERROR(B1<>"",B1,IFERROR(A1<>"",A1,"Empty")))

Using latest version
Getting error as "You have entered too many arguments for this functions"