why isn't this IF function working??

  • Thread starter Thread starter broken
  • Start date Start date
B

broken

=IF(D26<>0,D26,IF(E26<>0,E26))
It currently isn't recognizing the values in column E.

This is what I am trying to do:
If D has text, return that value. If E has text, return that value.

And if possible, can I also add this as the final IF variable:
If both are zero, return "Zero"

Thanks!!!
 
=IF(ISTEXT(D6),D6,IF(ISTEXT(E6),E6,0))
Thanks for the suggstion, but it still only returns values for column
D.
Not recognizing column E.
 
either touch the delete key in d1 or use this. someone touched the space bar
thereby returning a blank.

=IF(AND(D1<>" ",ISTEXT(D1)),D1,IF(ISTEXT(E1),E1,0))
 
=IF(ISTEXT(D6),D6,IF(ISTEXT(E6),E6,0))
Thanks for the suggstion, but it still only returns values for column
D.
Not recognizing column E.
Click to expand...

What does it return if there is nothing in Column D?


--ron
 
Back
Top