Maybe...

=if(a31="",na(),if(b31=0,c30+b31,c30+b31))

Did you mean to do the same expression in your formula?

=if(a31="",na(),c30+b31)
seems to the same.

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

--

Dave Peterson