Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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