Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Functions
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training day courses near kent - Functions
Resolved · Low Priority · Version Standard
Reply Tue 13 Nov 2007, 17:09Delegate Baerbel said...
Baerbel has attended:
Excel Intermediate course
Excel Advanced course
Functions
Please define 'IF' function
For upcoming training course dates see: Pricing & availability
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.
|