엑셀에서 성적 처리를 위해 중첩 IF 문을 쓰다가 개수에 한계가 있음을 발견하였다.

=IF(M2<=20, "A+", IF(M2<=33, "A", IF(M2<=38, "A-", IF(M2<=68, "B+", IF(M2<=78, "B", IF(M2<=82, "B-", IF(M2<=102, "C+", IF(M2<=105, "C", IF(M2<=108, "C-", "F")))))))))

위와 같은 수식을 실행하면 다음과 같은 에러에 직면한다.

사용자 삽입 이미지

그래서 할 수 없이 다음과 같이 C까지만 자동으로 처리하고 C-는 수동으로 처리했다.

=IF(M2<=20, "A+", IF(M2<=33, "A", IF(M2<=38, "A-", IF(M2<=68, "B+", IF(M2<=78, "B", IF(M2<=82, "B-", IF(M2<=102, "C+", IF(M2<=105, "C", "F"))))))))



해결 방법을 알면,

plz, comment :-)
Posted by izeye

댓글을 달아 주세요

  1. Cheap Oakley sunglasses 2013.07.23 02:56  댓글주소  수정/삭제  댓글쓰기

    좋으면 좋고 싫으면 싫은 거지, 뭐가 이렇게 어렵고 복잡하냐구

Marshalling

Computer/Terms 2007. 12. 21. 15:51

Marshalling (also known as serialization) is the process of transforming the memory representation of an object to a data format suitable for storage or transmission. It is typically used when data must be moved between different parts of a computer program or from one program to another.

The opposite, or reverse, of Marshalling is called Unmarshalling (also known as deserialization).
- Marshalling is heavily used within Microsoft's Component Object Model (COM), where it is necessary for transporting data between processes and between apartments. The conversion between an unmanaged type and a CLR type, as in the P/Invoke process used in the .NET Framework, is also an example of an action that requires marshalling to take place.
- Additionally, Marshalling is used extensively within scripts and applications that utilize the XPCOM technologies provided within the Mozilla Application Framework. The Mozilla Firefox Browser is a popular application built with this framework, that additionally allows scripting languages to utilize XPCOM through Cross-Platform Connect (XPConnect).

The terms "marshalling" and "serialization" are not synonymous.
- To "marshal" an object means to record its state and codebase(s) in such a way that when the marshalled object is "unmarshalled," a copy of the original object is obtained, possibly by automatically loading the class definitions of the object. You can marshal any object that is serializable or remote. Marshalling is like serialization, except marshalling also records codebases. Marshalling is different from serialization in that marshalling treats remote objects specially.
- To "serialize" an object means to convert its state into a byte stream in such a way that the byte stream can be converted back into a copy of the object.

Reference:
http://en.wikipedia.org/wiki/Marshalling
Posted by izeye

댓글을 달아 주세요

Maven

Computer/Tools 2007. 12. 21. 11:48

Maven is a software project management and comprehension tool. Based on the concept of a project object model (POM), Maven can manage a project's build, reporting and documentation from a central piece of information.



Comments:
JiBX 관련 글을 읽다가 Maven에 대한 이야기를 보고 표시를 해둔다.

소프트웨어 프로젝트 관리 도구로서 많이 사용되는 모양이다.

시간이 날 때 익혀둬야지!

사용해본 분이 있다면, comment를 부탁합니다 :-)



Reference:
http://maven.apache.org/index.html
Posted by izeye

댓글을 달아 주세요