Percentages of numbers

Clooney

New Member
Joined
Sep 28, 2012
Messages
36
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.
 
Last edited:

Some videos you may like

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
Joined
Oct 24, 2012
Messages
3,937
Office Version
  1. 365
Platform
  1. MacOS
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
Joined
Sep 28, 2012
Messages
36
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!!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,273
Messages
5,527,712
Members
409,784
Latest member
AdamPriest

This Week's Hot Topics

Top