rounddowns

  • Thread starter Thread starter Joseph A.
  • Start date Start date
J

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!!
 
Joseph A. said:
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!!
Click to expand...

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}))
 
Back
Top