Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
hi members, i need help on how to use wild cards(*/?) with if logical function. please provide me example. -- b166er ------------------------------------------------------------------------ b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
It's better if you tell us more about what you want to do; then someone may think of ways to solve your problem. I don't know of any wildcards with IF functions. Regards mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
It's better if you tell us more about what you want to do; then someone may think of ways to solve your problem. I don't know of any wildcards with IF functions, but something I DO know may be just what your problem needs. Regards mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
thankyou for reply here is my problem A1:A10 contains different jobnumbers in that format 32/2240,32/2425,32/4040 and so on and B1:B10 contains amount. job code 32/4040 first two diget for budget head(32) second for expence(40) third for location(40). in cell C1:c10 i just want to show particular location amount if there would have been wild cards i could get that by using following format A1:A10=32/??40 or A1:A10=32/??25 and so forth how can i get that result. -- b166er ------------------------------------------------------------------------ b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
Is this acceptable?
=SUMPRODUCT(--(RIGHT(A1:A10,2)="40"),--(B1:B10)) "b166er" wrote: thankyou for reply here is my problem A1:A10 contains different jobnumbers in that format 32/2240,32/2425,32/4040 and so on and B1:B10 contains amount. job code 32/4040 first two diget for budget head(32) second for expence(40) third for location(40). in cell C1:c10 i just want to show particular location amount if there would have been wild cards i could get that by using following format A1:A10=32/??40 or A1:A10=32/??25 and so forth how can i get that result. -- b166er ------------------------------------------------------------------------ b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
OK, here's one way: With data as you describe, in range A1:J2, and with row 1 A:J named jobs and with row 2 A:J named data in K2 type: =SUMPRODUCT((LEFT(jobs,2)="32")*(RIGHT(jobs,2)="40 ")*(data)) The values of 32 and 40 could be stored outside this cell; say they are held in L2 and M2, then the formula can be written: =SUMPRODUCT((LEFT(jobs,2)=TEXT(L2,"0"))*(RIGHT(job s,2)=TEXT(M2,"0"))*(data)) Hope this is helpful Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
b166er Try this: This formula sums the Col_B values where Col_A begins with "32/" and ends with "40": =SUMIF(A1:A10,"32/*40",B1:B10) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild card with if logical function
Nice method Ron, thanks for sharing it! Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=547358 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to use a wild card in a =COUNT(IF equation? | Excel Worksheet Functions | |||
Logical Function Question | Excel Worksheet Functions | |||
Logical AND function | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions |