| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounddowns
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 |
Threaded Mode
