Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - IF
|
|
|
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 - IF
Resolved · Low Priority · Version Standard
Reply Wed 17 Oct 2007, 15:21Delegate Cassy said...
For upcoming training course dates see: Pricing & availability
RE: IF
Hi Cassy
Thank you for your question.
Normally you will need to look at the function and troubleshoot this yourself. Common mistakes are:
- missing brackets, or not including enough brackets if you are creating a nested if funtion
- if you are using numbers as part of any of the arguments of the function, including commas within the numbers (e.g. 1,000 instead of 1000) will confuse Excel as it will think where the comma is within the number is where you have ended that particular argument
- not including a 'value if false' argument as the final argument in a nested if function.
- putting in the wrong symbol, e.g using > as less than rather than greater than.
I hope this helps.
Amanda
|