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
Takumin
Feb 05, 2019Copper Contributor
=IF(H6="Y",G6*5%,"")