View Single Post
 
Old 01-06-2015, 06:32 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

That's because you are doing the OR part of the IF instead of adding the terms. Also, there's no need for the quotation marks. This is what you should use...

=IF(C7="X",15%,0) + IF(G7="X",10%,0) + ...

i.e. IF C7 = X, add 0.15, ELSE add 0 + IF G7 = X, add 0.10, ELSE add 0
Reply With Quote