I have a formula that correctly shows the cost of having 1 child in a class. When the parent has 2 or more children the cost is £5 per extra child per week.

They could be in either Weeks FM or WeeksSR.

So far I have a column showing “extraChildren” / number of weeks /class fm/ class sr/ but my formula is wrong and I have no idea what it should be.

Once I have the correct total I will need to add that to the combined Total Amount

The Amount formula is already very complex so how would I add it.IF({No of weeks FM}, VALUE(RIGHT({No of weeks FM}, LEN({No of weeks FM})- FIND(“£”, {No of weeks FM}))), 0)+IF({Zoom}, VALUE(RIGHT({Zoom}, LEN({Zoom})- FIND(“£”, {Zoom}))),0)+IF({Party}, VALUE(RIGHT({Party}, LEN({Party})- FIND(“£”, {Party}))), 0)+IF({No of weeks S&R}, VALUE(RIGHT({No of weeks S&R}, LEN({No of weeks S&R})- FIND(“£”, {No of weeks S&R}))), 0)

Any help you can give me on this would be greatly appreciated as no matter what I read about formula, I am afraid I can’t seem to follow the logic.