Excel Formula Help Please!

[Maui13]

Hi guys,


I'm no Excel guru but have an idea and would like some help please.
This should not take longer than 5 minutes to someone who knows their way around Excel

33

8

9

13

If I have those numbers in an Excel spreadsheet, I just want it in the cell to the right, to tell me what dozen the number is in. 33 - 3, 8 - 1, 9 - 1, 13 - 2. If there is a ZERO to mark it as a ZERO.


That's it! Very simple! I think - I had something like IF(36>=25,3,IF(24>=13,2,IF(12>=1,1)))
But that didn't work!!!   


Thanks in advance!
Regards
M

[Stepkevh]

cells
     A    B
1  33
2   8
3   9
4  13
5

Type this formula in B1 

=IF(A1="";"";IF(A1=0;0;IF(A1<=12;1;IF(AND(A1>12;A1<=24);2;IF(AND(A1>24;A1<=36);3;"")))))

then it should work.
then just copy the cell downwords.

[Maui13]

Hi Stepkevh


Thanks for the help! Unfortunately I get an error that the formula is incorrect and it highlights the section (in red bold)

=IF(A1="";"";IF(A1=0;0;IF(A1<=12;1;IF(AND(A1>12;A1<=24);2;IF(AND(A1>24;A1<=36);3;"")))))

[Stepkevh]

i dont know what version of excel you use.

SO try this one

=ALS(A1=0;0;ALS(A1<=12;1;ALS(EN(A1>12;A1<=24);2;ALS(EN(A1>24;A1<=36);3;""))))

or in english

=IF(A1=0;0;IF(A1<=12;1;IF(AND(A1>12;A1<=24);2;IF(AND(A1>24;A1<=36);3;""))))

[Stepkevh]

hope this helps more

[Maui13]

FANTASTIC!!! Thank you very much!

[Stepkevh]

your welcome 

in fact its the easiest thing to do