April 25, 2012

Excel forumula, enter data then a letter appears in another cell

Problem: How to enter a letter in one cell and another cell displays a number (or any character) corresponding to entered data?

cell K3 needs this forumulae;

cell L3 needs this forumulae;

So, user will enter D or N in cell G3
and in the same time cell K3 will display 1, and L3 will display zero.
If user enters some other letter than D or N, both cells will display 0.

No comments: