Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical functions
Dear
i m using excel logical functions for some calculation, eg =IF(AND(C2="EBRK",K2=1),0.0001,IF(AND(C2="EBRK",K2 1),J2/K2,IF(AND(F21,E21),0.0001,IF(AND(J2<-2000),0.0001,IF(AND(E2100000),1,IF(AND(K2=10000), 3,IF(AND(F21),2,(J2/K2)*4))))))) but now i want to add some more logic but excel not allowes me. plz tell me how i can add or simplyfy my formula |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical Functions | Excel Discussion (Misc queries) | |||
using logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
Logical Functions | Excel Programming | |||
Logical Functions | Excel Programming |