why isn't this IF function working??

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!!!
 
B

broken

=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.
 
D

Don Guillett

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))
 
R

Ron Rosenfeld

=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
Function or If statement help 1
Formula HELP 1
Excel Formula Help 2
If condition for Blank Cell 4
Mulitple Workbooks and Ignoring Blank Cells 5

Top