i have this formula

=IF(E9="Yes",J9+K9-N9,IF(E9="No",K9-N9))
which works ok but i have had to omit a cell because the formula does not like it as its an empty cell (but has a formula in it)

this is how i would like the formula to look like.

=IF(E9="Yes",J9:L9-N9,IF(E9="No",J9:L9-N9))
but result is #Value