Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Conor has attended:
Excel Advanced course
why can you only use a limited no. of "if's" in a forumla?
Conor
This is the result of a programming limitation, and cannot be overwritten, leaving a maximum of 7 sub if expressions in an If statement.
regards
Best Team
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.
Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.
To convert these numbers to actual values, click on an empty cell and press Ctrl+C.
Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
