If OR functions

J

Jim

I have three columns
Column A is titled "income"
Column B is titled "prin"
Column C is titled "tax code"
All of the information will be in a row. I need help in writng a formula to
put the tax code in column c. for example if $100.00 was entered in col A
then we need 203 to be entered in Column C. If $100.00 was entered in col B
then we need 204 to be entered in col C
 
M

MD Websunlimited

Hi Jim,

This really should be in the programming NG instead of this general discussion group.

To accomplish will require a knowledge of JavaScript programming.

The entry into the row / col I've assumed will be via input boxes. Also, I believe the problem statement is understated for example
what happens if 100 is not entered in R1C1 but 'ADE' is entered instead.

The code to accomplish this problem as stated would be:

<input type="text" name="R1C1" onblur="if(this.value == 100 ) {this.form.R1C3.value = 203}" >
<input type="text" name="R1C2" onblur="if(this.value == 100 ) {this.form.R1C3.value = 204}" >
 
S

Stefan B Rusynko

Sounds more like an Excel question than a Web form question
- the perils of the new Web based Newsgroup interface

Maybe the user needs to ask in an Excel newsgroup




| Hi Jim,
|
| This really should be in the programming NG instead of this general discussion group.
|
| To accomplish will require a knowledge of JavaScript programming.
|
| The entry into the row / col I've assumed will be via input boxes. Also, I believe the problem statement is understated for
example
| what happens if 100 is not entered in R1C1 but 'ADE' is entered instead.
|
| The code to accomplish this problem as stated would be:
|
| <input type="text" name="R1C1" onblur="if(this.value == 100 ) {this.form.R1C3.value = 203}" >
| <input type="text" name="R1C2" onblur="if(this.value == 100 ) {this.form.R1C3.value = 204}" >
|
|
| >I have three columns
| > Column A is titled "income"
| > Column B is titled "prin"
| > Column C is titled "tax code"
| > All of the information will be in a row. I need help in writng a formula to
| > put the tax code in column c. for example if $100.00 was entered in col A
| > then we need 203 to be entered in Column C. If $100.00 was entered in col B
| > then we need 204 to be entered in col C
|
|
 
Top