excel word powerpoint courses london - if statement

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - IF Statement

excel word powerpoint courses london - IF Statement

resolvedResolved · Low Priority · Version Standard

Kerry has attended:
Excel Advanced course

IF Statement

If: How to check why a formula isn't working

RE: IF Statement

Hi Kerry

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


Server loaded in 0.08 secs.