Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF Functions
Vanessa has attended:
Excel Intermediate course
Excel Advanced course
How many nested IF functions can be done?
Hi Vanessa, Thank you for your post, in answer to your question;
You can nest up to seven IF's in one statement.
regards Pete
If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:
1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells
To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
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.
