Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |