Forum Discussion
Vesperwind
Oct 06, 2023Copper Contributor
Sum and Subtract multiple cells with blank values without having the #Value Error
Hello folks! Once again I need your precious help. I have a sheet where I need to sum and subtract various amounts on the same row. It would be very simple if it weren't for the "#Value" Error. I...
- Oct 06, 2023
Change
=E2 + I2 - L3
to
=N(E2) + N(I2) - N(L3)
or
=NUMBERVALUE(E2) + NUMBERVALUE(I2) - NUMBERVALUE(L3)
HansVogelaar
Oct 06, 2023MVP
Make the formulas return 0 instead of "".
Vesperwind
Oct 06, 2023Copper Contributor
Thanks Hans for your reply. Isn't there any other way as far as you know?
I'd prefer to keep the cells empty for various reasons (empty means a thing while 0 means another).
I'd prefer to keep the cells empty for various reasons (empty means a thing while 0 means another).
- HansVogelaarOct 06, 2023MVP
Change
=E2 + I2 - L3
to
=N(E2) + N(I2) - N(L3)
or
=NUMBERVALUE(E2) + NUMBERVALUE(I2) - NUMBERVALUE(L3)
- VesperwindOct 06, 2023Copper ContributorThank you very much