Condition now returns error

[Pat]

With M29 containing a condition V29 returns a #VALUE! error.

V29 =J29+I29+M29

M29 =IF(J29="","",J29)

What change do I need to make to the formula in V29 so an error does not
appear.

Thanks
Pat

[Chip Pearson]

You'll get an error in V29 if J29, I29, or M29 contains a text
value. You can have a formula ignore text values by using the SUM
function. E.g.,

=SUM(J29,I29,M29)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Pat" <glass_patrick@hotmail.com> wrote in message
news:Oow%23r$4FFHA.1924@TK2MSFTNGP14.phx.gbl...
> With M29 containing a condition V29 returns a #VALUE! error.
>
> V29 =J29+I29+M29
>
> M29 =IF(J29="","",J29)
>
> What change do I need to make to the formula in V29 so an error
> does not
> appear.
>
> Thanks
> Pat
>
>

[Ragdyer]

Try this:

=SUM(J29,I29,M29)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Pat" <glass_patrick@hotmail.com> wrote in message
news:Oow%23r$4FFHA.1924@TK2MSFTNGP14.phx.gbl...
> With M29 containing a condition V29 returns a #VALUE! error.
>
> V29 =J29+I29+M29
>
> M29 =IF(J29="","",J29)
>
> What change do I need to make to the formula in V29 so an error does not
> appear.
>
> Thanks
> Pat
>
>