Using nested IF functions is a common way to conditionally test, although try to avoid seven if possible as it requires a lot of effort to understand.
If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.
If you need to nest more than 7 times it is strongly recommended that you split the formula into separate pieces.
Use a named ranges to define your smaller bits. IF(OneToSix,OneToSix,SevenToThirteen), whereOneToSix has 6 nested IF statements and SevenToThirteen has another 7.
This function can return an array formula.
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext