shimaa01234
Active Member
- Joined
- Jun 24, 2014
- Messages
- 446
Can Shortening this formula
=IF(X6="Successful","Not choose",IF(AND(X6="Residuum",SUM(SUM(IF(E6<$E$5,$E$5-E6),IF(I6<$I$5,$I$5-I6),IF(M6<$M$5,$M$5-M6),IF(Q6<$Q$5,$Q$5-Q6),IF(U6<$U$5,$U$5-U6)),W6)<$W$5),"choose","Not choose"))
=IF(X6="Successful","Not choose",IF(AND(X6="Residuum",SUM(SUM(IF(E6<$E$5,$E$5-E6),IF(I6<$I$5,$I$5-I6),IF(M6<$M$5,$M$5-M6),IF(Q6<$Q$5,$Q$5-Q6),IF(U6<$U$5,$U$5-U6)),W6)<$W$5),"choose","Not choose"))