Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

# Round a Value with the reference of Another Value

Brass Contributor

# Round a Value with the reference of Another Value

Here attached the excel sheet.

Refer to the Video.

5 Replies
best response confirmed by ajmal pottekattil yoousuf (Brass Contributor)
Solution

# Re: Round a Value with the reference of Another Value

=TEXT(E3,IF(E4<1,"0."&REPT("0",-LOG(E4)),"0"))

# Re: Round a Value with the reference of Another Value

The Resolution of UUT is changed the value is not popup properly.

# Re: Round a Value with the reference of Another Value

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.

# Re: Round a Value with the reference of Another Value

Does this do what you want?

=TEXT(E3,IF(E4<1,"0."&REPT("0",-ROUNDUP(LOG(E4),0)),"0"))

1 best response

Accepted Solutions
best response confirmed by ajmal pottekattil yoousuf (Brass Contributor)
Solution

# Re: Round a Value with the reference of Another Value

=TEXT(E3,IF(E4<1,"0."&REPT("0",-LOG(E4)),"0"))