Hi Joseph:
Try this out.
=ROUNDDOWN($E$1/LOOKUP($E24,{"a",1;"b",12;"c",45;"d",3}),IF(OR($E2 4 =
"a",$E24 = "d"),0,IF(OR($E24 = "b",$E24 = "c"),1)))

hth
J Feaver


"joseph" wrote in message
...
I have - =Rounddown('check
one'!E1/Lookup($E24,{"a",1;"b",12;"c",45;"d",3}),0)
The rounddown number is zero for a,b,c,&d. I wish to have different
rounddown numbers for a,b,c,&d.
0 for a ; 1 for b; 1 for c; 0 for d, how do I do that?
Thanks for any help or
direction - Joseph