microsoft excel training day courses near kent - functions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Functions

microsoft excel training day courses near kent - Functions

resolvedResolved · Low Priority · Version Standard

Baerbel has attended:
Excel Intermediate course
Excel Advanced course

Functions

Please define 'IF' function

RE: functions

Hi Baerbel, thank you for your post, in answer to your question the IF function is a "Decision" function which checks for a condition being met, if the condition is met IF will return TRUE and carry out a particular task, if the condition is not met IF will return a FALSE response and carry out another task. An example of the syntax is =IF(Logical test,value if true,value if false), or in plain language; =IF(A1>50,A1*2,0)
which means if the contents of A1 are greater than 50, multiply them by 2 if not then do nothing. I hope that helps, regards Pete.


Server loaded in 0.08 secs.