View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anil_Indian Anil_Indian is offline
external usenet poster
 
Posts: 1
Default 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