Feb 04 2019 06:08 PM
Hi There, I am needing help with the followingI6 - needing to calculate 5% of G6 ONLY when H6 says YCheers, Bianca
Feb 04 2019 07:42 PM
=IF(H6="Y",G6*5%,"")
Feb 05 2019 05:39 AM
Or
=0.05*G6*(H6="Y")