| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logically Calculating Multiple Fields
Hello,
I would like to see if someone can help me with this calculation. If cell E2 is 10% or above, we would like cell H2 to add one for each cells of A2, B2 and C2 that have a score of 6 or higher. Essentially: If: A2=6, B2=6, C2=5 and E2=10% then H2=2. And: A2=6, B2=6, C2=6 and E2=10% then H2=3 Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel MDI/SDI/Excel Instance to behave more logically | Setting up and Configuration of Excel | |||
| subtotaling on multiple fields | Excel Discussion (Misc queries) | |||
| Using COUNTIF on multiple fields | Excel Worksheet Functions | |||
| how do I add multiple fields together? | Excel Worksheet Functions | |||
| Calculating fields in pivot tables | Excel Discussion (Misc queries) | |||
Threaded Mode
