Hi,

a different approach could be a formula in M2 to be copied down

=F2*IF(I2="YES",0.5,1)

Hope it helps