02-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
02-04-2019 07:42 PM
=IF(H6="Y",G6*5%,"")
02-05-2019 05:39 AM
Or
=0.05*G6*(H6="Y")