Why you chose 0.1 and 0 for the number values?

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?

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