Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF statements

IF statements

ResolvedVersion 2010

Mon 25 Feb 2013, 16:36 Delegate Zipporah said...

Zipporah has attended:
Excel Intermediate course
Excel Advanced course
Project Introduction course
Project Intermediate course

IF statements

I can't get my IF statement to work. Could you have a look at it and let me know where I am going wrong please.

=IF(FC6={31475,55821,78211,37058},"A",IF(FC6={76351,37108},"B",IF(FC6={37119,37830},"C",IF(FC6={37118,78652,37117},"D",IF(FC6={37109,39117,40270},"E",IF(FC6={45850,30414},"F",IF(FC6={76351,37107,62008,42591,42420,30813},"G",Other)))))))

It recognises the first number in some of the statements and for the rest returns "#NAME?"

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

IF statements

IF statements

Excel articles

Excel tip:

Make macros work in newer versions of Excel