Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
I want help on lookup functions i wrote up to 100000 but i want up to
1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
See if this formula gives the intended results up to 1000000:
=IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5))) Hope this helps, Hutch "Srinivas" wrote: I want help on lookup functions i wrote up to 100000 but i want up to 1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
Thanks for the reply
Actual the scenario is like this from 1 to 25000 - the bank will charge 25 as commision and from 25001 to 50000 - 50 then after 50001 to 55000 - 55 and 55001 to 60000 - 60 ..........etc i want formula up 100000. But if nothing there like 0 it should display "0" Thanks -- srinivas "Srinivas" wrote: I want help on lookup functions i wrote up to 100000 but i want up to 1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
Thank you it helped me but even if nothing is there it is giving 25, if no
amount is there it should display "0" -- srinivas "Tom Hutchins" wrote: See if this formula gives the intended results up to 1000000: =IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5))) Hope this helps, Hutch "Srinivas" wrote: I want help on lookup functions i wrote up to 100000 but i want up to 1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
Okay, here is revised version which will return 0 if B224 is empty or
contains a zero. =IF(OR(LEN(B224)=0,B224=0),0,IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5)))) Hutch "Srinivas" wrote: Thanks for the reply Actual the scenario is like this from 1 to 25000 - the bank will charge 25 as commision and from 25001 to 50000 - 50 then after 50001 to 55000 - 55 and 55001 to 60000 - 60 ..........etc i want formula up 100000. But if nothing there like 0 it should display "0" Thanks -- srinivas "Srinivas" wrote: I want help on lookup functions i wrote up to 100000 but i want up to 1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup functions
THANKS LOT
-- srinivas "Tom Hutchins" wrote: Okay, here is revised version which will return 0 if B224 is empty or contains a zero. =IF(OR(LEN(B224)=0,B224=0),0,IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5)))) Hutch "Srinivas" wrote: Thanks for the reply Actual the scenario is like this from 1 to 25000 - the bank will charge 25 as commision and from 25001 to 50000 - 50 then after 50001 to 55000 - 55 and 55001 to 60000 - 60 ..........etc i want formula up 100000. But if nothing there like 0 it should display "0" Thanks -- srinivas "Srinivas" wrote: I want help on lookup functions i wrote up to 100000 but i want up to 1000000 how to do this using lookup or any other. =LOOKUP(B224,{0,25000,50001,55001,60001,65001,7000 1,75001,80001,85001,90001,95001,100001},{"25","50" ,"55","60","65","70","75","80","85","90","95","100 "}) -- srinivas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If ,AND, LOOKUP, Functions | Excel Worksheet Functions | |||
lookup functions | Setting up and Configuration of Excel | |||
Lookup functions | Excel Discussion (Misc queries) | |||
Lookup Functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions |