Forum Discussion
BiancaAngel
Feb 05, 2019Copper Contributor
IF or SUMIF to calculate percentage of a cell based on a cell trigger
Hi There, I am needing help with the following I6 - needing to calculate 5% of G6 ONLY when H6 says Y Cheers, Bianca
SergeiBaklan
Feb 05, 2019Diamond Contributor
Or
=0.05*G6*(H6="Y")