K Ken Wright Nov 3, 2004 #2 It can be done quite easily with the IF function but it doesn't scale very well, so if you had more than 7 IFs you would crash, but CHOOSE and MATCH will allow many more arguments than that.
It can be done quite easily with the IF function but it doesn't scale very well, so if you had more than 7 IFs you would crash, but CHOOSE and MATCH will allow many more arguments than that.
