JuJuBeeCopper ContributorJun 22, 2026SolvedRounding Issues I am trying to create a "change maker" spreadsheet. We have a need to determine monetary denominations for several clients for refunds... A B C D E F G H I J K L Random Money ...Show MoreIlirUJun 22, 2026Hi JuJuBee,Try below formula in cell D2 (drag it right and down).=INT(ROUND(($B2 - (SUMPRODUCT(ROUND($C$1:C$1, 2), ROUND($C2:C2, 2)))), 2) / D$1)or more shorter:=INT(ROUND(($B2 - (SUMPRODUCT($C$1:C$1, $C2:C2))), 2) / D$1)HTHIlirU
IlirUJun 22, 2026Hi JuJuBee,Try below formula in cell D2 (drag it right and down).=INT(ROUND(($B2 - (SUMPRODUCT(ROUND($C$1:C$1, 2), ROUND($C2:C2, 2)))), 2) / D$1)or more shorter:=INT(ROUND(($B2 - (SUMPRODUCT($C$1:C$1, $C2:C2))), 2) / D$1)HTHIlirU
IlirUJun 22, 2026Hi JuJuBee,Try below formula in cell D2 (drag it right and down).=INT(ROUND(($B2 - (SUMPRODUCT(ROUND($C$1:C$1, 2), ROUND($C2:C2, 2)))), 2) / D$1)or more shorter:=INT(ROUND(($B2 - (SUMPRODUCT($C$1:C$1, $C2:C2))), 2) / D$1)HTHIlirU
IlirUIron ContributorJun 22, 2026Hi JuJuBee,Try below formula in cell D2 (drag it right and down).=INT(ROUND(($B2 - (SUMPRODUCT(ROUND($C$1:C$1, 2), ROUND($C2:C2, 2)))), 2) / D$1)or more shorter:=INT(ROUND(($B2 - (SUMPRODUCT($C$1:C$1, $C2:C2))), 2) / D$1)HTHIlirU
