Trying to remove negative result in cell

[blogger153]

I have a formula as below:

=SUM(K7)-AVERAGEIFS('2 TURN'!$K:$K,'2 TURN'!$F:$F,$F7,'2 TURN'!$G:$G,$G7)

The 2nd part of the formula returns an average figured which is subtracted from the figure in cell K7. Sometime the K column doesn't have a value but has N/A (not available). When this is the case, this formula returns a negative result = to the average in the 2nd part of the formula.

Is there a way I can have the formula return "N/A" is some non-numerical value when the cell in the K column (as per example, K7) has N/A ?

Many thanks

[Punnam]

Hi,
Try this
=iferror(SUM(K7)-AVERAGEIFS('2 TURN'!$K:$K,'2 TURN'!$F:$F,$F7,'2 TURN'!$G:$G,$G7),"N/A")

Punnam

[BadlySpelledBuoy]

=IF(K7="N/A","N/A",YourFormulaHere)

[Bob Phillips]

AS far as I can see, if K7 holds N/A, then the result is N/A.