Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help me ! I want to create two or more functions work in one cell.
I want to create two or more functions to works in one cell, respectively:
IF(AND(B5=B21,A5=A22),SUM(C5),"") and IF(AND(B5=B21,A6=A22),SUM(C6),"") Independently they work but when I’m ordering one by one in sell appears FEALS. I tried to apply before OR , IF(OR …. , but something’s wrong. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
One way:
=(B5=B21)*((A5=A22)*C5 + (A6=A22)*C6) In article , "peter via OfficeKB.com" wrote: I want to create two or more functions to works in one cell, respectively: IF(AND(B5=B21,A5=A22),SUM(C5),"") and IF(AND(B5=B21,A6=A22),SUM(C6),"") Independently they work but when I’m ordering one by one in sell appears FEALS. I tried to apply before OR , IF(OR …. , but something’s wrong. |
#3
|
|||
|
|||
I’m afraid but it doesn’t work. I want to execute one of that two results,
or C5 or C6. -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
Could you give specific examples of what "doesn't work"?
What if A5=A22 and A6=A22? In article , "peter dimitrakis via OfficeKB.com" wrote: I’m afraid but it doesn’t work. I want to execute one of that two results, or C5 or C6. |
#5
|
|||
|
|||
A5 AND A6 are the names of products. B5 is data, C4 and C5 are quantity of
the same products. This is the part of the consignation table. This is the first table. The second table: A22 is the name of the product, B21 is data and I aply formula in B22 (is quantity of first product on first day of the second table). I want to compare the names and check data and if they are the same as in second table to aply quantity from first to second table. If not the same to aply nothing. The problem is that the consignation table has two or more products and I have to check data and then product by product ... I hope you understend , this is very difficult for me. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a formula out of more than 7 functions in excel? | Excel Worksheet Functions | |||
Create a function to return text if two logical functions are true | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
Create AutoSubtotal button which functions like the AutoSum butto. | Excel Worksheet Functions | |||
How do I create complex functions? | Excel Worksheet Functions |