I have a data entry worksheet in Excel that have four cells:
Annual Comp. Rate
Hourly Comp. Rate
Change Amount
Change Percent
The user should be able to enter an amount in any of those four fields. After the user enters the data in one cell the rest must be calculated automatically.
How can I do that?