# Percentages of numbers

#### Clooney

##### New Member
So Im working on a sheet to measure performance in our warehouse.

A1=226 cases per hour
B1 = 74% (performance)

In order for me to see what A1 would look like if B2 were 100% I make a formula like this "A1/B1" which equals 306 cases per hour.

That's all fine and dandy, but what if i want to see A1 at 105%,110%,112%,115%.......(this is totally possible since we have several people who can bust out 145%).

What I want to do in another cell is be able to type the percentage i want to see and have it update the number in A1 to Cell C1.

Any help would be greatly appreciated.

Last edited:

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### etaf

##### Well-known Member
IN C1 you have the actual cases per hour if 100% - 306 - if you want to see that change in cell C1 to a number you input

IN say D1 you put 105%
then modify C1 to be
(A1/B1)*D1

now if you just want to see without the modification you added just put in 100%

which brings you back to 306

Last edited:

#### Clooney

##### New Member
IN C1 you have the actual cases per hour if 100% - 306 - if you want to see that change in cell C1 to a number you input

IN say D1 you put 105%
then modify C1 to be
(A1/B1)*D1

now if you just want to see without the modification you added just put in 100%

which brings you back to 306

That did the trick, thank you so much!!

Replies
10
Views
544
Replies
8
Views
960
Replies
3
Views
281
Replies
3
Views
270
Replies
4
Views
63