Don’t manually round them via rounding functions. Just format the cell to display a certain number of digits. It’s like wondering why after rounding 1/3 to be 0.33, you get 0.33*3 = 0.99 and not 1. Excel does calculations with the stored value, not the displayed value. Even without manually rounding, with many numbers it’s still technically possible for floating-point errors to occur with addition on seldom occasions. More on reddit.com

Hello, Making spreadsheets where I put the cost price into a cell and in another cell, it adds our markup to it and presents the result. This is the formula I'm using: =IF(B34=0,"x",B34*1.92) The "x" part is that not everything has a price, so I wanted it to display x rather than zero in... More on mrexcel.com

(I need to change the formula later to fix something.)

You can try this formula, which should round the percentage to the nearest whole number:

ifs(
	prop("Formula")>1,
		"■■■■■■■■■■" + " │100%",
	prop("Formula")<0,
			"□□□□□□□□□□" + " │0%",
substring("■■■■■■■■■■", 0, 10 * prop("Formula"))
+
substring("□□□□□□□□□□", 10 * prop("Formula"))
+ " │"
+ let(
    number,
        100 * prop("Formula"),
    if(
        number-floor(number)>=0.5,
            ceil(number),
        floor(number))) 
+ "%")

You also have this formula, but it looks more like a typical progress bar, so it might not be the kind of style you want:

lets(
	formula2,
		if(prop("Formula")>1, 1, prop("Formula")),
	formula3,
		100 * prop("Formula"),
ifs(
	and(prop("Formula")>=0.995, prop("Formula")<1),
		" ".repeat(9).split("").map(current.style("blue", "blue_background", "c", "u")).join(" ")+ " " + " ".style("grey_background", "c") + " │100%",
	prop("Formula")<0,
			" ".repeat(10).split("").map(current.style("grey_background", "c")).join(" ")+" │0%",
[" ".repeat(floor(10*formula2)).split("").map(current.style("blue", "blue_background", "c", "u")).join(" "),
" ".repeat(10-floor(10*formula2)).split("").map(current.style("grey_background", "c")).join(" ")].filter(!empty(current)).join(" ")
+ " │"
+ if(
		formula3-floor(formula3)>=0.5,
			ceil(formula3),
		floor(formula3))
+ "%"))

This is how the second one looks like:

You can find more progress bar designs here:

https://www.redgregory.com/notion/2021/6/4/17-progress-bar-designs-in-notion

Oh yeah, and you also have Notion's progress bar if you want to use that.

More on reddit.com

=if(a1-floor(a1,.01)>=.006,ceiling(a1,.01),floor(a1,.01)) More on reddit.com