| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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),"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Linear Mode
