=IF(G3="D";1;0)
cell L3 needs this forumulae;
=IF(G3="N";1;0)
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.
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;
=IF(G3="D";1;0)
cell L3 needs this forumulae;
=IF(G3="N";1;0)
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.
=IF(G3="D";1;0)
cell L3 needs this forumulae;
=IF(G3="N";1;0)
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment