how to combine 3 formulas into 1 pls

i have 3 bits of formula on one row but need them to combine into just one however there is an error on the sheet the throws up #VALUE could someone please take a look and possibly help.

thank you in advance

Hi flyinghigher2011

try changing the equation in cell O8 to this

=IF(K8="",SUM(J8-I8)*L8+(M8*I8)-(L8/4)*3,(SUM(J8-I8)*L8+(M8*I8)-(L8/4)*3)+K8)

Replace all your cell references with this. E.g if its L8, make it IF(ISNUMBER(L8),L8,0). Do this for all cell references in your formula like M8, K8 etc. This will return you a valid formula

In your current formula, replace all
L8 with IF(ISNUMBER(L8),L8,0)
M8 with IF(ISNUMBER(M8),M8,0)
and so on, one by one.