Please read forum rules. Titles with Help or please help etc are not permitted.

Try,

=(C4/100)*$D$31

VBA Noob