#VALUE error

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),"")
 
J

JoeU2004

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 -----
 
T

T. Valko

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?
 
B

BadBoy

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting update issue 5
long formula 7
Pls Help - blank cell/formula issue 7
fourmla with result no less than assigned value 1
How can I return zero after a max value has been met? 7
maxa function results in value error in worksheet 2
ignore text in formula 11
Use TODAY() function as the criteria in a SUMIF formula 1

Top