How do I enter the formula for volume of a cylinder in Excel?
May 24, 2009 · With radius in A1 and height in B1, enter this formula (PI x Raidus x Radius x Height) in C1 =3.14* ( (A1)^2)*B1 For PI you may use a higher precision number in place of …
How to refresh a sheet automaticaly (without pressing F9)
Mar 26, 2004 · there is a timer event but its quirky and i wouldn't suggest using it. Try putting your code in the Workbook_SheetChange event of 'ThisWorkbook' in your project window, that way …
calculate moles in excel - PC Review
May 10, 2008 · Hi, So it's homework time is it? Firstly you can't do it solely in Excel without reference to a table of atomic weights and from that you should discover the following:- …
Calculating age from date of birth and ignoring if blank
Nov 24, 2010 · I've used the following formula to calculate a person's current age in years based on a previously entered date of birth: =ROUNDDOWN(YEARFRAC(P2, TODAY(), 1), 0) …
Calculating age differences - PC Review
Sep 26, 2007 · I have two columns: chronilogical age and reading age. I need to calculate the difference between these ages. Age displayed as eg. 10:01 (10 years and 1 month) actual …
How do I add and subtract engineering stations in Excel?
Feb 26, 2009 · I'm trying to calculate the distance between two known Stations (i.e. 100+00 and 200+00) for an easy measure of plan quantities. The Difference between these two points is …
Calculate Stanine Values - PC Review
Aug 14, 2013 · Is there a function to calculate stanine values in Excel? If so, could this be done en-bloc? By this I mean, calculate all columns simultaneously, rather than individually. See …
how do I get STDEV () 2 sigma? - PC Review
Jan 24, 2006 · When you have a data set and calculate the stdev, that value is the Sqrt of the variance of the data. If you assume the data is normally distributed, then the stdev is an …
Compound interest calculation in a query - PC Review
Aug 8, 2004 · I use a query to age accounts receivable but need help in calculting the interest on past due receivables. We want to calculate the interest compounded...
Creating auto loan database - PC Review
Nov 24, 2007 · Very rusty beginning access user wants to create db to track, record, and calculate car payments made by customers at used car lot. Currently using excel spreadsheet …