Desktop

Ask something
Discussion Locked

Enter data in one cell, calculating thre

0 helpful
6 replies

by wgonzlez 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

6 replies

by grimreality

Before I could possible give an answer I would need some more info. Such as what are teh calculations that would need to be done.

by wgonzlez

Variables Definitions:
Previous Annual Comp. Rate = PACR
Annual Comp. Rate = ACR
Hourly Comp. Rate = HCR
Change Amount = CAMT
Change Percent = CPCT

Calculations to be Done:

If ACR is entered by user
HCR := ACR/2080
CAMT := PACR-ACR
CPCT := CAMT/PACR
If HCR is entered by user
ACR := HCR * 2080
CAMT := HCR-PHCR
CPCT := CAMT/PHCR
and so on. I hope these calcs give you the idea. I know this can be done in VBA but I've never worked with VBA neither have idea of how to begin.

This discussion is closed to new replies.