If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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),"") |
#2
|
|||
|
|||
#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),"") |
#3
|
|||
|
|||
#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),"") |
#4
|
|||
|
|||
#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),"") |
Thread Tools | |
Display Modes | |
|
|