Why you chose 0.1 and 0 for the number values?
Isn't it more precise to write manually the lowest and highest numbers (in this example's case: -90.5% and +80.5% ?
3 answers ( 0 marked as helpful)
Hi!
Thanks for reaching out.
Of course, Excel allows us to manually insert numeric values. However, its power and huge advantage is that it allows us to automate calculations in a very efficient and intuitive way. Perhaps, if we add the lowest and highest values manually, they wouldn't be the correct values if we changed some of the rest of the values that relate to them. Therefore, in general, whenever we can automate a calculation, this should be our preferred choice.
Hope this helps.
Kind regards,
Martin
But how we chose these exact values "0.1" and "0", how we calculate them?