Use separate calculation to get values based of reference cell on another excel

Punssiliini

New Member
Joined
Mar 3, 2015
Messages
6
I have sheet of times in time format, lets say in seconds, like following..

A1=100 seconds
A2=200 seconds
A3=300 seconds

in B column, I have a divide calculation that converts seconds to wanted time format (ex.hours), =A1/3600, so values are

B1=0,027..
B2=0,055..
etc.

I also have total row, wich counts the sum of column B.

I Also have multiplier in one cell (lets say in C1) that marks how many times column A values happen.

This whole sheet is a separate excel, which by itself, is kind of a "balanced calculator".
Results I have from it basically are something like: We are going on a pace 5, we have X amount of "things", but when pace is 7, it's not the same as pace 5 +2 (bases on rounds and if formulas that are included in calculator itself).

So I'm asking is there a way, that when I have a separate excel sheet, where i have different paces on each week, could I make a formula that "changes" the multiplier value from my calculator excel and gives amount of "things" based on given pace.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Hi, I've read your post several times now and I don't really have any idea what you want to do exactly.

Can you please explain much more clearly ?

Don't worry about explaining the real world application of your situation, that might not be relevant.
Just focus on describing very clearly what data you have and EXACTLY what you want to do with it.
A couple of worked examples might be useful.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,384
Messages
5,601,326
Members
414,443
Latest member
lionking15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top