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

excel course in london - if condition

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course in london - IF condition

excel course in london - IF condition

ResolvedVersion Standard

Ben has attended:
Excel Intermediate course

IF condition

How does one use the IF condition?

RE: IF condition

Hello Ben, Thank you for your post, The IF function is used when you require to know if a condition is true or false, ie is 100 greater than 50? if the answer is true then you require a certain action to take place, if it is false then you require a different action to take place. The function is laid out like this; = IF(condition,true,false) so it would look like = =IF(100>50,100*2,0) translated means, if 100 is greater than 50, multiply 100 by 2, if not do nothing. Get the jist?

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

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.