2. Then enter this formula: =IF(C$1<=$B3,1,IF(ROUNDUP($B3,0)=C$1,MOD($B3,1),0)) into the cell C3, and drag the fill handle down to the cells you want to fill this formula, see screenshot: Note: In the above formula, B3 is the cell contains the rating number, and C...