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
2 Replies
Sort By
Or
=0.05*G6*(H6="Y")
- TakuminCopper Contributor
=IF(H6="Y",G6*5%,"")