Thread: #VALUE error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default #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),"")