|
| 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
September 18th, 2009, 05:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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
September 18th, 2009, 05:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
September 18th, 2009, 05:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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
September 18th, 2009, 05:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 | |
|
|
Linear Mode
