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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help on GPA formulas with null value 1
Counting calculated formulas in a Column 3
Counting # of Formulas in a column with formulas and entered data 1
Why doesn't this formula work, please? 4
Can Conditional Formatting do this? 9
Formula HELP 1
Excel Formula Help 2
Function or If statement help 1

Back
Top