Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function
Erglend has attended:
Excel Advanced course
Can if function be used with string values in a cell ?
Hi Erglend,
Thank you for your question.
If you are creating IF functions you can refer a string.
Here is an example:
=if(H2="Brown",h8*2.5,h8*3.5)
I hope this answers your question.
Regards
Simon
Fri 20 Nov 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.
To convert these numbers to actual values, click on an empty cell and press Ctrl+C.
Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
