Nice.
Question... is there a spreadsheet function for handling subranges better than nested if statements?
Say I have a value X, and I want to return 1 if x < y, 2 if y < x < z, 3 if z < x < q, etc.
--
Sucrose Octanitrate.
Proof positive that with sufficient motivation, you can make anything explode.
Question... is there a spreadsheet function for handling subranges better than nested if statements?
Say I have a value X, and I want to return 1 if x < y, 2 if y < x < z, 3 if z < x < q, etc.
--
Sucrose Octanitrate.
Proof positive that with sufficient motivation, you can make anything explode.