Cell N40 and N41 use the same formula, same conditional formatting, and same cell formatting only difference is the cell reference in the formula which is the respective row. But, as you can see in Fig. 1-2 cell 41 shows two decimal places, but I can’t figure out why that would be, it should be zero decimal places.
Fig. 1-1 (Cell N40 Formula and view)
Fig. 1-2 (Cell N41 Formula and View)
Fig. 1-3 (Cell Formatting)
Fig. 1-4 (Conditional Formatting)