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
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
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.
Hi Stepkevh
Thanks for the help! Unfortunately I get an error that the formula is incorrect and it highlights the section (in red bold)
Quote from: Stepkevh on Sep 21, 03:26 AM 2012
=IF(A1="";"";IF(A1=0;0;IF(A1<=12;1;IF(AND(A1>12;A1<=24);2;IF(AND(A1>24;A1<=36);3;"")))))
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;""))))
hope this helps more :)
FANTASTIC!!! Thank you very much! :thumbsup: :thumbsup: :thumbsup:
your welcome :xd:
in fact its the easiest thing to do :)