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

Joseph,

See if this works for you...

=ROUNDDOWN('check
one'!E1/LOOKUP($E24,{"a",1;"b",12;"c",45;"d",3}),LOOKUP($E 24,{"a",0;"b",1;"c",1;
"d",0}))

Regards,
Jim Cone
San Francisco, CA

"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

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