Forum Discussion
Adding numbers in appropriate ranges
Hello, I'm looking for a method to add the right number of numbers when a certain range is exceeded. For example, =< 10 +1, =< 20 +2, etc. It is supposed to happen after receiving the truth in the ...
Without further clarification it's hard to answer your question, so I'll take a shot in the dark.
Let's say the number you're assessing is in A1.
=CEILING(A1,10)/10