Roll Length Formula

[Alone In Californian Sky]

I need help to setup a calculator to measure the length of material left on a roll.

The goal is to enter 2 dimensions and have formulas spit out 3 results depending on the materials thickness. Outer diameter in A5, Inner diameter in B5 will give results based on the material thickness.




Thanks to anyone who can help me with my problem.

 

[p45cal]

try in cell B8:

=PI()*($A$5^2-$B$5^2)/4/$A8/1000

and copy down.

 

[Alone In Californian Sky]

try in cell B8: =PI()*($A$5^2-$B$5^2)/4/$A8/1000 and copy down.

Thank you, that worked perfectly.

Would you mind explaining to me what the Open then closed bracket after PI achieves? Also, what is the significance of the '$' signs?

Tried all manner of configuration, but didn't think to add either of those.

 

[p45cal]

The parentheses after PI is just what Excel expects! It returns 3.14159.......
The $ symbols are all about absolute v. relative cell references, see:

Switch between relative and absolute references - Microsoft Support

Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column references.

support.microsoft.com

Difference Between Absolute and Relative Reference in Excel

Difference between relative and absolute reference in Excel. Download the practice book, go through the article, give yourself a try.

www.exceldemy.com