Can you nest SUBSTITUTE in an IF syntax?

[Nanaia]

Is it possible to nest SUBSTITUTE within an IF formula? I have a column that has a range of numbers in it that I want to combine in a TEXTJOIN string. However IF the number is a decimal, I need to substitute the decimal with an underscore. i.e. instead of 6.875 it needs to be 6_875. I'm not sure how to do it though. Can anyone help?
Thanks.

If you want more details, just let me know.

DRW	FACE	TEXTJOIN
25	6.875	25_6_875
25	11.375	25_11_375
18A	36	18A_36

<tbody>
</tbody>

 

[brharrii]

Would this work:

=Concatenate(DRW, Substitute(FACE, ".", "_"))

 

[AlKey]

Try this

[B]=SUBSTITUTE(A1&"."&B1,".","_")[/B]

 

[Nanaia]

bharrii - this brought me very close to what I wanted, however I needed an underscore between the DRW and the FACE as well as where the decimal is. Thank you for your help though!

 

[Nanaia]

AlKey - you gave me the idea to just plug the substitute into my TEXTJOIN formula again. I tried it without the IF portion and it worked! I must've been over thinking it. (Go figure) Thanks for your help!

 

[brharrii]

bharrii - this brought me very close to what I wanted, however I needed an underscore between the DRW and the FACE as well as where the decimal is. Thank you for your help though!

To add the underscore:

=Concatenate(DRW, "_", Substitute(FACE, ".", "_"))