Hi everyone,
I'm creating a spreadsheet where I am trying to specifiy a future date based on three criteria;
1) a date
2) a 'level' (either a value of '2' or '3')
3) a 'credit' value, which will fall into 1 of four ranges
Because the credit falls into a range rather than a fixed value I'm struggling to even get started; I did think a lookup or Index function or something, but calculating which range the credit value belongs in has lost me. In the attached spreadsheet I have included the criteria table, the bands and the expected output (you can ignore columns H and J for this).
I hope that makes sense, if not let me know what you need. I am learning so much from this forum and consequently that's got me trying to do more and more which leads to these problems!
Thanks in advance,
Dabooka
Bookmarks