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

if function

ResolvedVersion 2007

Sujal has attended:
Excel Intermediate course

IF function

Does the IF statement always have to following the sequence; Question, True, False ?

RE: IF function

Yes

RE: IF function

Saying that, it can get a bit confusing because your true or false can be more than true or false, ie, you might nest another function as the true or false. If you have a more specific example you would like me to look at let me know.

Thanks
Paul

Wed 23 Nov 2011: Automatically marked as resolved.

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

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.