Counting of smiliar type of data based on certain conditions

[OMKARTHEPOWER]

Hi All

I have a set of data in a single column stated below :

30.32
73.82
133.99
51.93
51.77
54.55
55.24
60.95
60.95
60.95
52.35

<tbody>
</tbody>

Now if i want to get the final result where all rows ending with .95 should be true or else false, how can i derive through simple excel formula.

Thanks in advance in anticipation to get positive response.

 

[OMKARTHEPOWER]

Thanks for the support but formula is not fully workable for me.

Reason being in case of (126.24, 413.92) it should have returned as true as it contains number before decimal which is divisible by 13. I mean last 2 digit before decimal.

Might be i didnt wrote it correct while framing the question. my apologies for the same.

Another quick question: can't it be in a single formula?

Regards
Anand

 

[Snakehips]

Excel 2007
	A	B
1	126.64	TRUE
2	118.64	FALSE
3	413.92	TRUE
4	13.39	TRUE
5	58.39	FALSE
6	58.39	FALSE
7	13.39	TRUE
8	58.39	FALSE
9	206.09	TRUE
Sheet9

Cell Formulas
Range	Formula
B1	=OR(MOD(ROUND(A1-INT(A1),2)*100,9)=0,MOD(INT(MOD(A1,100)),13)=0)

 

[OMKARTHEPOWER]

Thanks a lot once again. Will check and let you know in case I face any issue.

Regards
Anand

 

[OMKARTHEPOWER]

Hi .

Please find below the output of formula suggested by you.

58.39	TRUE
58.39	TRUE
58.39	TRUE
58.39	TRUE
58.39	TRUE
143.13	TRUE
39.81	TRUE
39.81	TRUE
39.81	TRUE
72.13	TRUE
36.13	TRUE
349.00	TRUE
539.46	TRUE
22.13	TRUE
193.13	TRUE
22.13	TRUE
250.91	TRUE
1099.00	TRUE
132.00	TRUE
63.00	TRUE
599.00	TRUE

<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

I used the formula as OR(MOD(ROUND(A1-INT(A1),2)*100,13)=0,MOD(INT(MOD(A1,100)),13)=0).

Re-wirting the condition again for your quick reference.

1) Any figure after decimal which is divisible by 13 should be true( for e.g. .13,.26,.39,.52,.65,.78.till.91 ) or

2) Any figure before decimal which which ends with 13 or its multiple (to a maximum of two digit result.. i.e. to say till 91 as 104 becomes three digit result) should be true. Rest all should be false.

Still not getting perfect result.. for e.g.1099,132,63,599,349 etc should have resulted in false, but using the above formula it returned as true.

Sorry to bother you again and again.. but if you can help me to get the desired output as stated above.

Thanks in advance.

Best Regards
Anand

 

[Snakehips]

Re-wirting the condition again for your quick reference.

1) Any figure after decimal which is divisible by 13 should be true( for e.g. .13,.26,.39,.52,.65,.78.till.91 ) or

In post #8 you stated

1) Any figure after decimal which is divisible by 9 should be true( for e.g. .09,.18,.27,.36,.45,.54. and so on)

Which is it to be?

I would appear to have neglected to account for a whole number yielding a modulus of zero.
Why not see if you can modify the formula by incorporating an AND function to test for that?????