rounddowns

[Guest]

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

 

[Jim Cone]

Joseph,

See if this works for you...

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

Regards,
Jim Cone
San Francisco, CA

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

 

[Jim Feaver]

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

hth
J Feaver

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.