Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
I'm still relatively new to the formulas - can't do anything too complex yet
so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
This says that if the sum of cells A1 through A10 equals zero, then return
nothing ( "" ), else return the sum of A1 through A10. =IF(SUM(A1:A10)=0,"",SUM(A1:A10)) HTH, Paul -- "MrReeLady" wrote in message ... I'm still relatively new to the formulas - can't do anything too complex yet so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
hi
replace your basic sum formaulas with this.. =if(Sum(A2:A10)=0,"",Sum(A2:A10)) or =if(A9=0,"",A9) lots of variations on this. Regards FSt1 "MrReeLady" wrote: I'm still relatively new to the formulas - can't do anything too complex yet so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
If you want to show a blank if the total is zero, then you could use
=IF(SUM(A2:A100)=0,"",SUM(A2:A100)) but this would give a blank if you have genuine numbers that sum to zero. If you want a blank result if all the input cells are blank, then try =IF(COUNT(A2:A100),SUM(A2:A100),"") -- David Biddulph "MrReeLady" wrote in message ... I'm still relatively new to the formulas - can't do anything too complex yet so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
If it is merely a display of the value "0" that you want to eliminate but
don't care if the content of the cell is "0" then under Tools\Options\View uncheck the Zero values box -- EarlyBirdie "MrReeLady" wrote: I'm still relatively new to the formulas - can't do anything too complex yet so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formulas
Thank you all for your quick response. I wish I understood the formulas
more... "PCLIVE" wrote: This says that if the sum of cells A1 through A10 equals zero, then return nothing ( "" ), else return the sum of A1 through A10. =IF(SUM(A1:A10)=0,"",SUM(A1:A10)) HTH, Paul -- "MrReeLady" wrote in message ... I'm still relatively new to the formulas - can't do anything too complex yet so this should be an easy one for all you experts out there. I have cells that have basic Sum formula. If there is no value in any of the preceding cells, the total cell shows $0. I believe I can create a formula that says if the value is 0 then leave blank. I don't want to see the $0. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |