Formula for Specific number addition

[Sandpit]

Hi All,

I am looking for a formula to return a figure as follows:

Cell A3 is updated during an on going month, the result is to appear in A10 which which will update according to A3.

If A3 = 0 return 0

If A3 = 1 to 4 return 1

If A3 = 5 to 8 return 2

If A3 = 9 to 12 return 3

If A3 = 13 to 16 return 4

If A3 = 17 to 20 return 5

etc etc

Thanks in advance.

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

obviously if A3 can sit outside of 0-20 boundary you might want to add an IFERROR handler or pre-emptive test.

(whole numbers assumed given outlined bands)

[arthurbr]

Perhaps

Please Login or Register  to view this content.

in A10

[Sandpit]

Thanks very much, CEILING Formula works a treat!!

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save