# IF or SUM IF to calculate percentage of a cell based on a cell trigger

1. ## IF or SUM IF 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

2. ## Re: IF or SUM IF to calculate percentage of a cell based on a cell trigger

Try this;
Formula:
`Please Login or Register  to view this content.`

3. ## Re: IF or SUM IF to calculate percentage of a cell based on a cell trigger

Thanks so much, it worked!
If I dont enter Y it populates I6 with the word FALSE, is it possible just for it to be 0?

4. ## Re: IF or SUM IF to calculate percentage of a cell based on a cell trigger

Try this;
Formula:
`Please Login or Register  to view this content.`

5. ## Re: IF or SUM IF to calculate percentage of a cell based on a cell trigger

Your an expert thanks heaps, gave you a good recommendation!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1