IF function. How to substitute depending on condition in another text box

Hi there,

Can someone help me out please?

How do i create this function:

If text in box C1 has an underscore then substitute fullstop in D1 with PT0

Thankyou

This is what I got so far but doesn't work.

=IF(C4,"*_*"(=SUBSTITUTE(E4,".",".PT0.")),(=SUBSTITUTE(E4,".",".MAIN.")))

Try

=IF(ISNUMBER(SEARCH("_",C4)),SUBSTITUTE(E4,".",".PT0."),SUBSTITUTE(E4,".",".MAIN."))

IT WORKS! Fantastic Mr Topley. Thank you

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thankyou again.