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 - Josep