microsoft-excel-training - if

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 - IF

microsoft-excel-training - IF

resolvedResolved · Low Priority · Version Standard

Cassy has attended:
Excel Advanced course

IF

How to check why a formula isnt working?

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.1 secs.