Percentages of numbers

[Clooney]

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.

Please no VBA!

Any help would be greatly appreciated.

 

[etaf]

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

 

[Clooney]

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!!