General discussion

Locked

Data Entry in Excel 2000

By wgonzlez ·
I prepared a data entry form on Excel that have four fields:
Annual Compensation Rate:
Hourly Comp. Rate:
Change Amount:
Change Percent:

I need that when the user enters data in either one of those fields the rest be automatically computed without overwritting formulas. For example:

If the user enters 10.00 in Hourly Comp. Rate, the Annual, Change Amount and % be calculated. Or he changes his mind and enters 10000 in Annual Comp. Rate the rest be computed without overwriting the formulas.

Thanks,

Wgonzlez.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data Entry in Excel 2000

by California Dead Head In reply to Data Entry in Excel 2000

You can't do that. What you have to do is give them the 4 choices and have the output (formula's) come out in 4 different coulumns.

Collapse -

Data Entry in Excel 2000

by wgonzlez In reply to Data Entry in Excel 2000

Poster rated this answer

Collapse -

Data Entry in Excel 2000

by wgonzlez In reply to Data Entry in Excel 2000

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums