I’m making a calculator for fun in relation to a Roleplay group of mine. Essential a certain number, to number, equals another number. However, the way I’m writing it seems inefficient as I have been writing each number one by one like so:
Where A13 is the cell where people input their numbers. I was wondering if there was some way to go about this better? An example of how this works is:
1-4 = 1
5-8 = 2
9-12 = 3...etc.
Is there a way to write Number To Number ? Or any suggestions for how I could go about doing this better?