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

 

[Ragdyer]

Try this:

=SUM(J29,I29,M29)