Divided by two numbers

[robertdseals]

I have a number and I want to see if it is divided by 10 and/or 8. 16 would because it can be divided by 8. 36 would because 2 10's and 2 8's. 17 would not because although you could get a 10 out of it, you wouldn't have enough left for an 8. Any thoughts?

 

[6StringJazzer]

This description does not indicate an actual result that can be shown in an Excel cell.

Are you looking for a Yes or No to indicate whether a given number can be created by summing only 10's and 8's?

If that is correct, this sounds like an iterative problem that can only be solved by Solver or VBA. I don't think this can be done with formulas. What kind of solution are you open to?

What is the range of possible numbers? It might actually be easier to generate all possible numbers that meet your criteria up to your limit.

$scratch.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1		Number of 10's
2	Number of 8's	0	1	2	3	4	5	6	7	8	9	10
3	0	0	10	20	30	40	50	60	70	80	90	100
4	1	8	18	28	38	48	58	68	78	88	98	108
5	2	16	26	36	46	56	66	76	86	96	106	116
6	3	24	34	44	54	64	74	84	94	104	114	124
7	4	32	42	52	62	72	82	92	102	112	122	132
8	5	40	50	60	70	80	90	100	110	120	130	140
9	6	48	58	68	78	88	98	108	118	128	138	148
10	7	56	66	76	86	96	106	116	126	136	146	156
11	8	64	74	84	94	104	114	124	134	144	154	164
12	9	72	82	92	102	112	122	132	142	152	162	172
13	10	80	90	100	110	120	130	140	150	160	170	180
Sheet6

Cell Formulas
Range	Formula
C2:L2	C2	=B2+1
B3:L13	B3	=B$2*10+$A3*8
A4:A13	A4	=A3+1

 

[Rick Rothstein]

I have a number and I want to see if it is divided by 10 and/or 8. 16 would because it can be divided by 8. 36 would because 2 10's and 2 8's. 17 would not because although you could get a 10 out of it, you wouldn't have enough left for an 8. Any thoughts?

It sounds like you are looking for a TRUE result if the number can be divided by either 8 or 10 and FALSE otherwise. If that is the case...

=OR(MOD(A1,8)=0,MOD(A1,10)=0)

 

[6StringJazzer]

It sounds like you are looking for a TRUE result if the number can be divided by either 8 or 10 and FALSE otherwise. If that is the case...

That was my first impression but the example

36 would because 2 10's and 2 8's.

36 is divisible neither by 10 nor 8, but can be made as a combination of sums of 10's and 8's.

 

[robertdseals]

I would like to know if it can be divided by any combination of 10 or 8 or both.

 

[Rick Rothstein]

Your original description and your latest post, when taken together, are a little bit unclear to me. Let me ask this... what answer would you want for the numbers 18, 26, 28 and 34?

 

[robertdseals]

Your original description and your latest post, when taken together, are a little bit unclear to me. Let me ask this... what answer would you want for the numbers 18, 26, 28 and 34?

Yes, because 10 & 8, yes because 10 and two 8's, yes because two 10's and an 8, yes because 1 10 and three 8's.

 

[Dave Patton]

Does this work for you

T202205a.xlsm
	A	B
1	18	TRUE
2	26	TRUE
3	28	TRUE
4	34	TRUE
5
1b

Cell Formulas
Range	Formula
B1:B4	B1	=OR(--RIGHT(A1,1)={0,2,4,6,8})

 

[6StringJazzer]

Does this work for you

All this does is identify even numbers. The numbers 12, 14, 22, 32 should all fail but are TRUE from your formula.

I think the question worded very poorly* but I think what he really wants is clear. The number conforms if it can be calculated as 8x + 10y where x and y are non-negative integers.

@robertdseals you have not answered my question about the possible range of numbers. The simplest method is the lookup table that I already provided but I can provide a VBA solution if that is not adequate.

*None of these numbers can be divided by 8 or 10.

 

[6StringJazzer]

Here is a UDF that returns TRUE or FALSE:

Public Function EightTen(L As Long) As Boolean

   Dim i8 As Long
   Dim i10 As Long
   Dim Total As Long
   
   i10 = 0
   Do
   
      i8 = 0
      Do
         Total = i8 * 8 + i10 * 10
         If Total = L Then
            EightTen = True
            Exit Function
         End If
      
         i8 = i8 + 1
         
      Loop Until Total > L
      
      i10 = i10 + 1
      Total = 0
   
   Loop Until i10 * 10 > L

End Function