Adding a Formula that calculates 3, 6, 10 or 15 if "the cell" is 1-15, 16-40, and so on.
Hello,
I have column A, where I can input any number from 1 to 200+.
I need column B to display a "3" if A is 1 thru 15.
Display a "6" if A is 16 thru 40.
Display a "10" if A is 41 thru 80.
And display a 15 if A is 81 thru 140.
I hope I described this well enough to understand what I'm trying to get help with.
Thanks in advance!