Condition now returns error
 

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

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" wrote in message
...
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

Try this:

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

RD

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

"Pat" wrote in message
...
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