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: 
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: 
Home

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

BiancaAngel
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

98 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
Highlighted
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
Related Conversations
Trying to add multiple users to distribution group and getting error: Cannot validate argument
 Test SharePoint in Office 365 on 10-12-2019
4 Replies
Help with an IF AND formula
 aanaya6 in Excel on 04-01-2019
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
 thomasea in Excel on 03-20-2019
6 Replies
not able to type number and text in same cell?
 Deleted in Excel on 12-10-2017
2 Replies
A problem with the Zoom level of a Tab
 Tavory in Discussions on 11-07-2019
9 Replies
Outlook Message box GUI blacked out when sending attachment through Excel
 midohioboarder in Office 365 on 01-24-2020
0 Replies