Excel Nested IF’s Explained
Did you know we can use a nested IF formula to extend the number of logical tests and therefore, possible outcomes? Simply put, this is multiple IF’s nested in the one formula. Prior to Excel 2007 the limit of IF's you could nest in one formula was 7. Excel 2007 has increased this to an …