Another IF statement with cells without values

[rcb007]

I have the following formula that seems to be working, however, when the formula gets to a Row with a value in column A, its shows "00" in the formula cell. I am sure I am missing something simple to have it not show the "00".

=IF(AND($A1=$A1,$C1=0),$A1,IF(AND($A1=$A1,$C1=$C1),$C1,""))

 

[Joe4]

Can you explain exactly the logic you are trying to apply here?

Why are you checking:
$A1=$A1
and
$C1=$C1?

Values have to be equal to themselves, by definition. So I don't understand what you are trying to do there.

 

[rcb007]

Again, I am sure I am way nothing thinking about this clearly.

The formula I am trying to make is to take A1 Value and if C1 does not have value then stick with A1. However, if C1 has a value then, to use C1 instead of A1. Lastly If there are no values within A1, then show nothing.

 

[Joe4]

Try this:

=IF($C1<>"",$C1,IF($A1<>"",$A1,""))

 

[rcb007]

Thank you. Sorry bout that.

 

[Joe4]

Thank you. Sorry bout that.

No worries. You are welcome.