formula
 

I'm working in oil co. as stocks inventory . In example below under the
column MTD loss/gain the answer is automatic to capture the negative or
positive sign when I input the value under the calculated inv. and current
inventory column. Thesame in percent column.
In the 2nd row the figure is -773151 and it supposed to be +773151

pls help.


CALC INV CURRENT INV MTD LOSS/GAIN PERCENTS +/- .10%
2031178 2038991 -7813 -0.24
212292 985443 -773151 -8.59

formula
 

If you're subtracting Current Inv from Calc Inv the result is correct.

???

Biff

"mike" wrote in message
...
I'm working in oil co. as stocks inventory . In example below under the
column MTD loss/gain the answer is automatic to capture the negative or
positive sign when I input the value under the calculated inv. and current
inventory column. Thesame in percent column.
In the 2nd row the figure is -773151 and it supposed to be +773151

pls help.


CALC INV CURRENT INV MTD LOSS/GAIN PERCENTS +/- .10%
2031178 2038991 -7813 -0.24
212292 985443 -773151 -8.59

formula
 

Thanks
it works

"T. Valko" wrote:

If you're subtracting Current Inv from Calc Inv the result is correct.

???

Biff

"mike" wrote in message
...
I'm working in oil co. as stocks inventory . In example below under the
column MTD loss/gain the answer is automatic to capture the negative or
positive sign when I input the value under the calculated inv. and current
inventory column. Thesame in percent column.
In the 2nd row the figure is -773151 and it supposed to be +773151

pls help.


CALC INV CURRENT INV MTD LOSS/GAIN PERCENTS +/- .10%
2031178 2038991 -7813 -0.24
212292 985443 -773151 -8.59