Forum Discussion
Round a Value with the reference of Another Value
Here attached the excel sheet.
Refer to the Video.
=TEXT(E3,IF(E4<1,"0."&REPT("0",-LOG(E4)),"0"))
=TEXT(E3,IF(E4<1,"0."&REPT("0",-LOG(E4)),"0"))
The Resolution of UUT is changed the value is not popup properly.
In your previous example, the resolution was always a power of 10: 1 or 0.1 or 0.01 or 0.001.
Your current example isn't helpful since Range is the whole number 10. Please provide some relevant examples, for example with Range = 123.456 and Resolution = 0.7 or Resolution = 0.09 etc.
A sample workbook or a screenshot is easier for me than a video.
