Thank all for your input.
I have used Daves formula, that works fine.....thank you Dave.
--
WH99


"Pete_UK" wrote:

I'm not sure what your first formula is doing - you seem to be adding
C30 to B31 irrespective of the value of B31 (and if it were zero, then
it would not matter anyway) !! Should one of the terms be C30+B30 ?

Try this:

=IF(A31="","n/a",C30+B31)

if your first formula is correct, or this:

=IF(A31="","n/a",IF(B31=0,C30+B30,C30+B31))

if my suggestion is correct.

Hope this helps.

Pete

On Jun 27, 12:17 pm, WH99 wrote:
I have the following formula:
=IF((B31)=0,SUM(C30+B31),(SUM(C30+B31)))
How do I add the following to the formula:
If A31="",NA()
In other words, I want the formula to also look at cell A31 and if it is
empty then cell C31 to show NA or even show nothing.
--
WH99