IF Value can be divided by..

[Browneh89]

Hello,

I am attempting to write an IF statement where it looks at 2 cells and if either cell can be divisible by 4 (4/8/12/16 etc..) the result will show as "0" However if both of the values added together equal a divisible of 4 it shows as "1"

=IF(D2=8,0,IF(E2=8,0,IF((D2+E2)=8,1,0)))

So for example below

Is this even possible?

 

[jasonb75]

You can do that with

=SIGN(MOD(D2,4))

edit:- reading your post a second time, I think you might need

=IF(OR(MOD(D2:E2,4))=0,0,IF(MOD(D2+E2,4)=0,1,"oops"))

If you don't have an up to date version of office 365 (with dynamic arrays) then you will need to array confirm the formula with Ctrl Shift Enter.

 

[Browneh89]

You can do that with

=SIGN(MOD(D2,4))

edit:- reading your post a second time, I think you might need

=IF(OR(MOD(D2:E2,4))=0,0,IF(MOD(D2+E2,4)=0,1,"oops"))

If you don't have an up to date version of office 365 (with dynamic arrays) then you will need to array confirm the formula with Ctrl Shift Enter.

Thank you for your response Jason,

I have applied your formula with the MOD function however it still does not return the results I was looking for

Below is what it shows, perhaps I did not explain myself well.

 

[jasonb75]

I had parenthesis in the wrong place, I've corrected that and it looks like it works fine now.

Book1
	D	E	F
2	0	4	0
3	8	0	0
4	4	4	0
5	6	2	1
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=IF(OR(MOD(D2:E2,4)=0),0,IF(MOD(D2+E2,4)=0,1,"oops"))

 

[Browneh89]

I had parenthesis in the wrong place, I've corrected that and it looks like it works fine now.

Book1
	D	E	F
2	0	4	0
3	8	0	0
4	4	4	0
5	6	2	1
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=IF(OR(MOD(D2:E2,4)=0),0,IF(MOD(D2+E2,4)=0,1,"oops"))

Yes! this works fantastically Thank you!