Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

if function

ResolvedVersion 2007

Erglend has attended:
Excel Advanced course

IF function

Can if function be used with string values in a cell ?

RE: IF function

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.

Excel tip:

Importing Numbers in Excel 2010

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.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.