IF Function Query - Is this appropriate?|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hiya. I have a list of cost types. If the cost type is Staff Costs, I need to be able to take the value of that staff cost (appears in another cell), find 15 percent of it, and detail what that is in another cell. I’ve got to that point, but it’s taking the value of costs from rows detailing other cost types, which means when I total it in ANOTHER column, it’s adding double.

I don’t know if that makes sense!

But this is what i have so far:

=IF(C4=”Staff costs (direct and external)”,M4 *0.15,M4)

But when I then sum this, as I said, the cells that dont have staff costs as the type are still pulling through, so any total is including this. How do I negate anything BUT staff costs (direct and external) in this formula.

ANY HELP much appreciated! Thank you