Last answered:

24 Dec 2022

Posted on:

17 Dec 2022

0

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)
Instructor
Posted on:

18 Dec 2022

0

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

Posted on:

18 Dec 2022

0

But how we chose these exact values "0.1" and "0", how we calculate them?

Instructor
Posted on:

24 Dec 2022

0

Hi!

Thank you very much for your reply.

To make sure you are on the same page, can you please share the exact cells from the worksheet you are referring to? Thank you.

Looking forward to hearing from you.
Kind regards,
Martin

Submit an answer