rounddowns

[Joseph A.]

I have =Rounddown('pesticide'!E1/Lookup($E24,
{"a",1;"b",2;"c",3;"d",4}),0)
The rounddown # is zero for all but I want 1 for a, 0 for
b, 0 for c, and 1 for d. I cannot seem to get anything I
try to work. Help please!!

 

[Paul]

I have =Rounddown('pesticide'!E1/Lookup($E24,
{"a",1;"b",2;"c",3;"d",4}),0)
The rounddown # is zero for all but I want 1 for a, 0 for
b, 0 for c, and 1 for d. I cannot seem to get anything I
try to work. Help please!!

Is this what you are looking for?
=ROUNDDOWN('pesticide'!E1/LOOKUP($E24,{"a",1;"b",2;"c",3;"d",4}),LOOKUP($E24
,{"a",1;"b",0;"c",0;"d",1}))