Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with GEOMEAN - returns #NUM error | Excel Worksheet Functions | |||
ERROR | Excel Discussion (Misc queries) | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
RATE returns the #NUM! error value | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |