Forum Discussion
Excel formulas with round function
I would like to insert round() to a range of highlighted cells that includes existing formulas. Any help?
A reference :
I found a macro that round Here is a macro that will wrap a ROUND() function around all of your formulas within the active data area that have not already been ROUND()'ed.
For Each Cell In Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell))
If Cell.HasFormula Then
If Left(Cell.Formula, 7) <> "=ROUND(" Then
Cell.Formula = "=ROUND(" & Mid(Cell.Formula, 2, 1024) & ",5)"
Cell.NumberFormat = "0.00000"
End If
End If
Next Cell
End Sub
Please explain in more detail how and where you want ROUND to be inserted in a formula, preferably with some relevant examples. Perhaps you could attach a small sample workbook with "before" and "after" formulas.
HansVogelaar In the attached file, rating is based on achievement from 90% to above 120% (from rating 1 to 5). For example rating 1 is from <90% and rating 2 is from 90% to 95%. If the achievement is 95.6%, it should be rounded to 96%. If the achievement is 91.3%, it should be rounded to 91%. . How should I do?
In addition, I have inserted the FileName =GET.DOCUMENT(88) and the MTD Apr 2021 and YTD Apr 2021 is based on the FileName. However, when I change Excel name to KPI CY2021 CSRM_Apr to KPI CY2021 CSRM_May, the MTD and YTD name still refers to Apr instead of May. How do I fix this problem?
