Calculate by Groups of 4

I am trying to do a simple Excel calculation.
I am trying an IF with nested IF statements but I have to hard code the numbers and then it is not to infinity.
We sell an item in groups of 4.
When a cell contains the number that the customer needs then I want to know how many 'groups' of 4 they need to order.
Example
Customer Needs 12
A1 = 12/4
Answer in C3 = 3 -sets of 4 needed to be ordered.
------------------
Customer needs 13
A1 = 13/4
Answer in C3 = 4 -sets of 4 needed to be ordered.
-----------------------------------
0/4 = 0 sets needed
1/4 = 1 sets needed
2/4 = 1 sets needed
3/4 = 1 sets needed
4/4 = 1 sets needed
5/4 = 2 sets needed
6/4 = 2 sets needed
7/4 = 2 sets needed
8/4 = 2 sets needed
9/4 = 3 sets needed
10/4 = 3 sets needed
11/4 = 3 sets needed
12/4 = 3 sets needed
13/4 = 4 sets needed
14/4 = 4 sets needed
15/4 = 4 sets needed
16/4 = 4 sets needed
17/4 = 5 sets needed
18/4 = 5 sets needed
19/4 = 5 sets needed
20/4 = 5 sets needed
21/4 = 6 sets needed
22/4 = 6 sets needed
23/4 = 6 sets needed
24/4 = 6 sets needed
so on down .......

if your quantity is entered in col B

=IF(MOD(B1,4)<>0,INT(B1/4)+1,B1/4)

and copy down as far as you need

HTH

Ed

That worked.. You are awsome.....
Thanks

Hi,

Enter this formula in cell $B$1
=IF(OR(ISNUMBER(A1)=FALSE,A1<=0),0,IF(MOD(A1,4)<>0,INT(A1/4)+1,INT(A1/4)))

Enter your test values in cell $A$1

See if this is what you are looking for.

Best Wishes,
mtpSuresh

That worked... This is a great forum...
Thanks