Text in one cloum and want number in other

Was this post useful to you?

i m preparing sheet for students record.for tuition for SR.Kg till 6th
i am stuck here ,,,,,i have 2 column named "Std " and other " Monthly Fees"
what
i want is in that column ( Std) when ever i type any stander like Std
1,,, Std 6.. i should get its respective fees across it in next column
e.g
Column1 Column2   Column 3
2             2            (=Column1+Column2) ans is 4
but this is easy with numbers
i have test in one and i want whenever i type that particular std its fees in other column
e.g
Column1 Column2  
Std 1      400
Std 5      500
column will be single but std will be any from skg till 6th
any help from anybody can i expect.

ishi's picture
ishi
Thu, 09/27/2012 - 09:08

1 Answers for "Text in one cloum and want number in other "

Hi Ishi,
I would like to help but think this might be a language (understanding) issue on my side.
Could you kindly explain what you mean by the text:

"Column will be single" and "std will be any from skg till 6th" ?
in your question a bit more in detail please.

One might then be able to understand the querstion better.
Thanks and regards
starter99

Post your reply

Filtered HTML

  • Allowed HTML tags: <b> <br> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.