Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need a " IF THIS THEN _" formula
I need a formula that goes kinda like;
=SUM(F29:F30)+SUM(F23:F26), IF 0 OR bLANK THEN 0 |
#2
|
|||
|
|||
I need a " IF THIS THEN _" formula
Duke, if the cells are blank or 0 you will get 0. ???? could you provide
more information on what you want to do? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Duke" wrote in message ... I need a formula that goes kinda like; =SUM(F29:F30)+SUM(F23:F26), IF 0 OR bLANK THEN 0 |
#3
|
|||
|
|||
I need a " IF THIS THEN _" formula
If the sum of the two ranges I have = zero or if all of the cells are blank,
I would like this cell to display 0 (zero). "Paul B" wrote: Duke, if the cells are blank or 0 you will get 0. ???? could you provide more information on what you want to do? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Duke" wrote in message ... I need a formula that goes kinda like; =SUM(F29:F30)+SUM(F23:F26), IF 0 OR bLANK THEN 0 |
#4
|
|||
|
|||
I need a " IF THIS THEN _" formula
Like Paul said if all the cells are blank or the sum or the ranges is
zero then =SUM(F29:F30)+SUM(F23:F26) will display zero. If this is not what you are getting then from the menus ToolsOptionsView and make sure that Zero Values is checked. Regards Rowan Duke wrote: If the sum of the two ranges I have = zero or if all of the cells are blank, I would like this cell to display 0 (zero). "Paul B" wrote: Duke, if the cells are blank or 0 you will get 0. ???? could you provide more information on what you want to do? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Duke" wrote in message ... I need a formula that goes kinda like; =SUM(F29:F30)+SUM(F23:F26), IF 0 OR bLANK THEN 0 |
#5
|
|||
|
|||
I need a " IF THIS THEN _" formula
=IF(SUM(A40:A43)+(SUM(A30:A33))=0,"",SUM(A40:A43)+ SUM(A30:A33)) Try this it should work, this will leave the cell blank if there are no values to add. Did I understand this right ? -- bbuzz ------------------------------------------------------------------------ bbuzz's Profile: http://www.excelforum.com/member.php...o&userid=28466 View this thread: http://www.excelforum.com/showthread...hreadid=480956 |
#6
|
|||
|
|||
I need a " IF THIS THEN _" formula
=IF(SUM(A40:A43)+(SUM(A30:A33))=0,"0",SUM(A40:A43) +SUM(A30:A33)) This will return "0" in the cell if the cells your adding have no values if thats what you want. -- bbuzz ------------------------------------------------------------------------ bbuzz's Profile: http://www.excelforum.com/member.php...o&userid=28466 View this thread: http://www.excelforum.com/showthread...hreadid=480956 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |