Multiple combinations of numbers

[hsandeep]

D3=either of 1 or 0
D5=either of 100 or 200 or 0

Final D8 (formula required for this) as

IF D3=1 AND D5=100 then D8=888
IF D3=1 AND D5=200 then D8=999
IF D3=0 AND D5=0 then D8=0
IF D3=0 AND D5=100 then D8=0
IF D3=0 AND D5=200 then D8=0
IF D3=0 AND D5=0 then D8=0

How to accomplish?
Thanks in advance.

Book2.xlsx
	D	E	F	G	H	I
3	1	1	1	0	0	0
4
5	100	200	0	100	200	0
6
7
8	888	999	0	0	0	0
Sheet5

 

[arthurbr]

In D8 enter

=IF(OR(D3=0,D5=0),0,IF(AND(D3=1,D5=100),888,IF(AND(D3=1,D5=200),999,"")))

and pull right

 

[Fluff]

How about

=IF(OR(D3=0,D5=0),0,IF(D5=100,888,999))

 

[hsandeep]

How about

=IF(OR(D3=0,D5=0),0,IF(D5=100,888,999))

It works. Thanks Fluff

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Legacy 143009]

Alternative approach:
D8:

=IF(D3*D5=0,0,(D3*777)+((D5/100)*111))