Hello,

Need help with excel formuals, I have a spreadsheet with inventory items listed on it, It has 3 different Counts listed on it, and each count Column has a, "Discrepancy" column and "Discrepancy $" see below example.

ITem, Quantity, Count 1, Discrepancy, Discrepancy $; Count 2, Discrepancy, Discrepancy $; Count 3, Discrepancy, Discrepancy $.

What I need the Spreadsheet to do is as Follows:

1st Count

Qty  Count 1  Discrepancy, Discrepancy$  Count 2  Discrpancy  Descrepancy$  Count 3 Discrepancy Discrpancy $

40      40         0                 $ 0.00          0                0             $0.00              0                  0         $0.00 
24       60        36                  $36.00         0               36             $36.00            0                 36       $36.00
266     264      -2                   -8.00           0              -2              $8.00              0                  -2        $8.00


<code>2nd Count

Qty  Count 1  Discrepancy, Discrepancy$  Count 2  Discrpancy  Descrepancy$  Count 3 Discrepancy Discrpancy $

40      40         0                   $ 0.00          0                0               $0.00              0                  0         $0.00 
24       60        36                  $36.00        24               0               $0.00              0                 0          $0.00
266     264      -2                   -8.00           0               -2              $8.00              0                  -2        $8.00

3rd Count

Qty  Count 1 Discrepancy, Discrepancy$  Count 2  Discrpancy  Descrepancy$  Count 3  Discrepancy Discrpancy $

40      40         0                   $ 0.00          0                0               $0.00             0                  0         $0.00 
24       60        36                  $36.00        24               0               $0.00             0                 0          $0.00
266     264      -2                   -8.00           0               -2              $8.00             0                  -2         $8.00

</code>


If the 1st count of the inventory matches the quantity listed I need it to not carry over to the 2nd and 3rd count columns (automatically entering "0" for remainder columns, if there is a discrepancy in the count I need the 1st count to carry over to the 2nd count, and if the discrepancy is corrected in the 2nd count I need it to automatically enter "0" in the remainder columns, and if there is a discrepancy in the 2nd count I need it to carry over to the 3rd and final count.

If a discrepancy is corrected I need it to show discrepany amount corrected to "0" and for the, columns to automatically updated the remainder columns: "count" column, "discrepancy" column, and the "discrepancy $" Column.

Discrepancies will be overages and shortages.

Please Help!!

Thanks,
Debbie

Configuration: Windows XP Internet Explorer 6.0