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

if function

ResolvedVersion 2007

Tristan has attended:
Excel Intermediate course
Excel Advanced course

IF Function

How would I pick out individual characters within a cell and link it to an IF function?

RE: IF Function

You could use a LEFT/RIGHT/MID function to pick out individual characters. You would have to nest this function into the IF function.

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

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.08 secs.