T Function

[MARKEGANDERSON]

Hello All - I am trying to use the below formula

=IFERROR(T(INDEX(Dollar_Amount1,(MATCH(cmts,DTS_ID,0)))),"") - It returns empty

Whenever I use this one in the same cell

=IFERROR(INDEX(Dollar_Amount1,MATCH(cmts,DTS_ID,0)),"") - it returns 500

What I am trying to do is get rid off the zero if the value is empty.

 

[shaowu459]

=IFERROR(1/(1/INDEX(Dollar_Amount1,MATCH(cmts,DTS_ID,0))),"")1/INDEX(Dollar_Amount1,MATCH(cmts,DTS_ID,0)): when INDEX returns zero value, this part will return error, and then 1/this error returns error, and IFERROR will return "".1/INDEX(Dollar_Amount1,MATCH(cmts,DTS_ID,0)): when INDEX returns non zero value, for example 500, this part will return 1/500, and then 1/(1/500) will return the orginal value 500.

 

[MARKEGANDERSON]

Thanks you. I get a #value error when it is blank, and a "1" when there is value

The below works for similar cells.

=IFERROR(T(INDEX(Routing___1,(MATCH(cmts,DTS_ID,0)))),"")

But not for the defined name :Dollar_Amount1