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