You could set up a formula for secondary gross to test Tare to see if it is
0. If the secondary gross is known, you could key over the formula.

A B C D

Gross 2ndary Gross Tare Shrink


B2: =IF(C20,A2*(1-0.005),0)
D2: A2-B2


Or, you could set up an Estimated Secondary Gross column

A B C D
E
Gross 2ndary Gross Est 2ndaryGross Tare Shrink



C2: =IF(D20,A2*(1-0.005),0)
E2: =IF(B20,A2-B2,A2-C2)


If Tare is not numeric you can change the 0 test to <"" or use
ISBLANK(D2)=FALSE. I don't know of a way (without using VBA) to test a cell
for a formula versus a user entered value.








"rcmodelr" wrote:

I have a spreadsheet to maintain truck weights.

If the weighmaster enters a Gross, and a Secondary Gross, the spreadsheet
should calculate the amount of shrink (Gross - Secondary Gross).

If the weighmaster enters ONLY a Gross and a Tare weight, the spreadsheet
should give an ESTIMATED shrink calculation, then show the result of Gross -
Estimated Shrink in the Secondary Gross column.

How can I do this??? Only way I could think of is with some way to
determine whether Secondary Gross column cell contains a USER ENTERED NUMBER,
or still has the formula to arrive at the ESTIMATED secondary weight. If
Secondary Gross has a formula, then Shrink should be Gross * .005, and
Secondary Gross should show result of Gross - Shrink.

If BOTH Gross AND Secondary Gross cells contain user entered numbers, Shrink
should contain result of Gross - Secondary Gross.

Btw... My employer has Excel 2000. So please, if you have a solution, try
to make it one I can implement in Excel 2000.