This is probably an easy problem but I can't get my head around why it's not working. I am normally good with this but somehow my logic is not working.
Spreadsheet is attached.
What has gone wrong?
This is probably an easy problem but I can't get my head around why it's not working. I am normally good with this but somehow my logic is not working.
Spreadsheet is attached.
What has gone wrong?
In what way do you think it's wrong?
Rory
sorry. when I changed the threshold to 4,000,000,001 it defaults to 2.5bps but it's suppose to be 3 and if I changed to 2,000,000,000 it defaults to 3 and not 3.5
so i think it's to do with my formula
The way you have it set up you need to change the threshold in the table AND the formula.
Do it this way below and you only need to change the value in the table.
Split column L into two columns, put the lower values in column L (e.g. 0 and 1000000001 etc) and the higher values (1000000000 and 2000000000 etc) in column M.
Your table is now in L8:N11
Now change the formula in column F to
=VLOOKUP(E14,L$8:N$11,3,1)
Values from your original formula look ok to me (I only had a quick glance).
Last edited by Special-K; 11-25-2019 at 09:28 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks