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

excel london - nested ifs

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Nested IF's

excel london - Nested IF's

ResolvedVersion Standard

Ayo has attended:
Excel Advanced course

Nested IF's

How do you solve various degrees of criteria within a formula?

RE: Nested IF's

Hi Ayo,

Thanks for the question.

I think you mean how do you create various degrees of criteria and if that is your question you must start with the most extreme case and incrementally work down. So if you were looking at putting an IF function together for grade boundaries, for example, you would start with IF(A1>85%, "A", IF(A1>75%,"B"...... for up to 7 conditions. The if function must be in logical order

I hope that helps, if it doesn't answer your question get back to me!

Tracy

 

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.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.