|
|
#3
01-06-2015, 06:32 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can you add percentage (%) columns to a pivot table? | New Daddy | Excel | 2 | 11-23-2013 09:49 PM |
 How to total 12 columns and divide them to get a percentage
|
Triscia | Word Tables | 1 | 01-15-2013 07:39 AM |
|
overall percentage
|
ketanco | Project | 1 | 08-04-2012 05:56 AM |
| Segmentation with percentage | yazen | PowerPoint | 0 | 05-01-2012 07:55 AM |
| percentage on columns | 911 | Excel | 1 | 09-01-2010 09:28 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode