#VALUE! when using cells with IF formula

I am using an IF formula in cells which relate to other cells with formulas in them and getting the #VALUE! error showing. Have tried a couple of ways to try and get rid of this but nothing seems to work. Am I missing something obvious? I have attached a screenshot showing the formulas and one showing the #VALUE! errors - could someone let me know what I am doing wrong in this instance?formulas.jpgerror_formulas.jpg

It contains blanks in the calculation cells. Wrap the formula in a IFERROR condition: IFERROR(your formula,"")

Thank you - greatly appreciated