#VALUE error

  • Thread starter Thread starter BadBoy
  • Start date Start date
B

BadBoy

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 said:
This formula returns a #VALUE! error when empty.
[....]
=IF(SUM(F17+H17)>0,SUM(F17+H17),"")
Click to expand...

Try:

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


----- original message -----
 
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?
 
Thank you :P Well done!

JoeU2004 said:
BadBoy said:
This formula returns a #VALUE! error when empty.
[....]
=IF(SUM(F17+H17)>0,SUM(F17+H17),"")
Click to expand...

Try:

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


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

BadBoy said:
This formula returns a #VALUE! error when empty.

Can this be fixed?

Thank you in advance.


=IF(SUM(F17+H17)>0,SUM(F17+H17),"")
Click to expand...
Click to expand...
 
Back
Top