cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

IF or SUMIF to calculate percentage of a cell based on a cell trigger

BiancaAngel
Occasional Visitor

‎02-04-2019 06:08 PM

‎02-04-2019 06:08 PM

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

 

Screenshot 2019-02-05 at 2.35.11 PM.png

Labels:
134 Views
0 Likes
2 Replies
Reply
2 Replies
Takumin

‎02-04-2019 07:42 PM

‎02-04-2019 07:42 PM

Re: IF or SUMIF to calculate percentage of a cell based on a cell trigger

=IF(H6="Y",G6*5%,"")

0 Likes
Reply
Sergei Baklan

‎02-05-2019 05:39 AM

‎02-05-2019 05:39 AM

Re: IF or SUMIF to calculate percentage of a cell based on a cell trigger

Or

=0.05*G6*(H6="Y")
0 Likes
Reply