Can someone please help me. I'm trying to create a worksheet for my job, and I'm having serious problems.
My workbook has a data entry sheet on the 1st page to just enter data, then the 2nd page references those values & calculates various totals.
My problem is that on one particular formula "Dry Unit Weight", it has a formula of "(Wo / Vo) / (100 + % Moisture) x 100".
Wo = 1.3177
Vo = 0.0102
% Moisture = 16.2
( 1.3177 / .0102 ) / (100 + 16.2 ) * 100
129.1862 / 116.2 * 100
111.1757
Excel computes 1.3177 / .0102 to equal 128.66
Can someone please take a look at my workbook and tell me what I did wrong? If I type the numbers in directly, I get the correct answer, however my cells are referencing other cells & the formatting is probably causing this, but I've tried so much to correct it, I probably need to step away and let someone else look for the error.
My goal is to enter the data that I will find out onto the 1st page, and let the 2nd page do all the calculations. Then print that one page.
Any help is appreciated!! With all the soil samples we do each day, this worksheet will make all the difference.
Here is the workbook: http://www322.pair.com/bryanr72/temp...ompression.xls
Thanks!!
-Bryan
Bookmarks