Excel function problem

[Mathilda]

I'm having trouble with this excel function, to which is suspect the answer is really simple, but can't figure it out atm.

=IF(U28=S;U30;"0:00")
It's not accepting anything but numeric values for the condition, and I need it to accept text, specifically 'S'.
What do I do?

edit: Sorry, don't worry about, I've just worked it out.
In case someone's intrested, it's like this:
=IF(ISTEXT(U28);U30;"0:00")

 

[Dell19]

Try putting "S". Then it will work.

 

[Mathilda]

Afraid not. Nor 'S'.

 

[Dell19]

Works for me although I use , instead of ;

 

[Mathilda]

Intresting.
I've been scratching my head about it at work.
Now, at home, when I read your post, I thought I'll do a small example version
and post that and ask you to look at it.
And what do you know, it works
It must be down to the version of the program.
Or could it be some check box that hasn't been checked on the work one, but is on the one at home?

 

[Dell19]

Perhaps they are using a different version of excel that doesn't allow "" to represent text strings.