ExcelBanter - #VALUE error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #VALUE error (https://www.excelbanter.com/excel-worksheet-functions/243127-value-error.html)

badboy

#VALUE error

This formula returns a #VALUE! error when empty.

Can this be fixed?

Thank you in advance.

=IF(SUM(F17+H17)0,SUM(F17+H17),"")

joeu2004

#VALUE error

"BadBoy" wrote:
This formula returns a #VALUE! error when empty.
[....]
=IF(SUM(F17+H17)0,SUM(F17+H17),"")

Try:

=if(sum(F17,H17)0, sum(F17,H17), "")

----- original message -----

"BadBoy" wrote in message
...
This formula returns a #VALUE! error when empty.

Can this be fixed?

Thank you in advance.

=IF(SUM(F17+H17)0,SUM(F17+H17),"")

T. Valko

#VALUE error

Try it like this:

=IF(SUM(F17,H17)0,SUM(F17,H17),"")

You probably have a text entry in either or both cells. Are there formulas
in those cells that return a blank?

--
Biff
Microsoft Excel MVP

"BadBoy" wrote in message
...
This formula returns a #VALUE! error when empty.

Can this be fixed?

Thank you in advance.

=IF(SUM(F17+H17)0,SUM(F17+H17),"")

badboy

#VALUE error

Thank you :P Well done!

"JoeU2004" wrote:

"BadBoy" wrote:
This formula returns a #VALUE! error when empty.
[....]
=IF(SUM(F17+H17)0,SUM(F17+H17),"")

Try:

=if(sum(F17,H17)0, sum(F17,H17), "")

----- original message -----

"BadBoy" wrote in message
...
This formula returns a #VALUE! error when empty.

Can this be fixed?

Thank you in advance.

=IF(SUM(F17+H17)0,SUM(F17+H17),"")

All times are GMT +1. The time now is 04:51 AM.