microsoft excel training day courses near kent - 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.