Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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