Home » Forums » Open Source Learning Center » Question and Answer

Calculating a percentage IF = yes

Submitted by jenniferlagranduer on 13 February, 2015 - 15:54

Ok I need a formula that:
Will calculate a 12.5% of A1 if H1 is Yes and calculate 20.5% of A1 if G1 is yes. is this possible. I can't figure it out. Please help

‹ Need to protect formulas Grid in Excel 2013 doesn't work... ›
»

=A1*IF(H1="Yes",0.125,IF(G1="

Submitted by Yamor on 14 February, 2015 - 21:53.

=A1*IF(H1="Yes",0.125,IF(G1="Yes",0.205,0))

This returns the correct answer if one and only one of H1 and G1 have yes.

If both have yes, it returns 12.5% of A1. If neither have yes it returns 0.

If you would prefer something different in these circumstances, post what you'd like.

»

thank you Yamor, is there a

Submitted by jenniferlagranduer on 17 February, 2015 - 15:15.

thank you Yamor, is there a way to now add the percentages if H1 and G1 both if they both equal yes.

»

AND Function

Submitted by mec1981 on 18 February, 2015 - 06:03.

Hi Jennifer,

You can start the function with a nested AND in order to combine multiple factors before activating a true statement in an IF function.

I have added into Yamor's original function as follows:
=A1*IF(AND(H1="Yes",G1="Yes"),0.33,IF(H1="Yes",0.125,IF(G1="Yes",0.205,0)))

Regards
Mark

»

Or perhaps slightly

Submitted by Yamor on 18 February, 2015 - 08:19.

Or perhaps slightly easier:
=A1*(IF(H1="Yes",0.125,0)+IF(G1="Yes",0.205,0))

»