This content has been marked as final.
Show 2 replies

1. Re: Why I can't use the formula to add a number of value
Andrew Watson Mar 24, 2016 5:02 AM (in response to Natta O)Difference + 1 seems to work. The Difference numbers are so small, generally between 0.001 and 0.001 that adding 1 to those gives a number that's almost 1  i.e. 0.999 and 1.0001.
You can alter the formatting to show more decimal places to Difference + 1  but it will still appear as close to exactly 1 on your line chart as it almost is exactly 1.

2. Re: Why I can't use the formula to add a number of value
Natta O Mar 25, 2016 1:00 AM (in response to Andrew Watson)Thank you