I have a status column which shows the project cost category e.g. personnel costs, travel costs, subcontracting etc…
I then have a number column for the amount spent and a formula column to calculate the overheads calculated as an additional 25% of the amount spent.
the formula i have is
However I want to add an ‘IF’ rule to the formula so if the status is ‘subcontracting’ the overheads claimed amount will always be €0. so something like this:
Can anyone suggest the correct formula please.