Formulas help

[serge]

Hi everyone,

I need help with 3 related formula please.

I have the following values in the following cells:

A1= 12
B1= 24
C1= 35
D1= 48
E1= 55

The 1st one in F1 would give me 1 if a number is made from 2 ODD digit.

The 2nd one in G1 would give me 1 if a number is made from 2 EVEN digit.

The 3Rd one in H1 would give me 1 if a number is made from 1 ODD and 1 EVEN digit.

For this example :
F1 would return : 2
G1 would return : 2
H1 would return : 1

Thank you in advance for any help... Serge.

 

[JamesW]

The 1st one in F1 would give me 1 if a number is made from 2 ODD digit.

The 2nd one in G1 would give me 1 if a number is made from 2 EVEN digit.

The 3Rd one in H1 would give me 1 if a number is made from 1 ODD and 1 EVEN digit.

So no matter what the two digits are the result is always 1?

 

[serge]

No, my bad if I explained it wrong, what ever the formulas would find that would be the answer.
Thank you JamesW

 

[JamesW]

So the result for 12 would be: "1 ODD and 1 EVEN" ?

 

[Weaver]

"The 1st one in F1 would give me 1 if a number is made from 2 ODD digit."

How come this returns a 2 in your example from the number 12?

 

[serge]

Each formula would take the range A1:E1.

So F1 would return : 2 because the number 35 and 55 are made with 2 Odd digits each number.

and G1 would return : 2 because the number 24 and 48 are made with 2 Even digits each number.

and H1 would return : 1 because the number 12 is made with 1 Odd digit and 1 Even digit.

I hope it's a better explanation ?

Thank you.

 

[serge]

Can someone help me with this one please.

Thank you.

 

[Aladin Akyurek]

Can someone help me with this one please.

Thank you.

F1, control+shift+enter, not just enter:

=SUM(IF(LEN($A$1:$E$1)=2,IF(1-(MOD(MID($A$1:$E$1,1,1),2)=0),IF(1-(MOD(MID($A$1:$E$1,2,1),2)=0),1))))

G1, control+shift+enter, not just enter:

=SUM(IF(LEN($A$1:$E$1)=2,IF(MOD(MID($A$1:$E$1,1,1),2)=0,IF(MOD(MID($A$1:$E$1,2,1),2)=0,1))))

H1, control+shift+enter, not just enter:

=SUM(IF(LEN(A1:E1)=2,1))-SUM(F1:G1)

 

[serge]

Thank you Aladin,

This is not the first time that you have assisted me - appreciate all your help.

One question ,can a formula be put there without entering it with control+shift+enter, I'm not an excel master like you, trying to understand.

Thanks again... Serge.

 

[Aladin Akyurek]

Thank you Aladin,

This is not the first time that you have assisted me - appreciate all your help.

You are welcome.

One question ,can a formula be put there without entering it with control+shift+enter, I'm not an excel master like you, trying to understand.

Thanks again... Serge.

You need to understand such eventually...

=SUM(IF(LEN(A$1)=2,IF(1-(MOD(MID(A$1,1,1),2)=0),IF(1-(MOD(MID(A$1,2,1),2)=0),1))))

This works on A1 and requires just enter.

You could put this in A2 and copy across, giving you a set of results. If you sum the results, you will get the count which exactly the same as the one in F1, produced by the formula that works on the whole range of A1:E1 at once. Working on whole range using IF's requires an array formula, which must be signalled to Excel with control+shift+enter.