Excel Challenge 1 in Excel Fundamentals & help forums Posted September 30, 2022 =SUMPRODUCT(ROUNDDOWN(ROUNDUP(MOD(A1/10^(ROW(A1:A10)),1),5)*10,0)) 1
Excel Challenge 1
in Excel Fundamentals & help forums
Posted
=SUMPRODUCT(ROUNDDOWN(ROUNDUP(MOD(A1/10^(ROW(A1:A10)),1),5)*10,0))