Good Afternoon All,
Thank you for your continued efforts on this forum, it has been greatly appreciated.
I have a (hopefully) simple request - I am trying to create some forms where the value of one output cell is increased by 1 for every 4000 threshold increase in another cell.
So basically, if the value in the input cell is 4000 or smaller, then the output cell should say 1. If the input number is 4001, the output should increase to 2. If the number is anything below 8000, the output should still be 2. Only when it reaches another 4000 threshold should it go up by another one. So if the number was 8001, it should go to 3.
I have a sample attached if that makes more sense. I was previously using Cell/divided by 4000 but that wasn't really adequate as I don't want decimals. Any suggestions would be great!
Thank you in advance,
Bookmarks