Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
I have added a column of numbers using the following formula so the total
cell will be zero if there is nothing in the column: =IF(count(F8:F26),SUM(F8:F26),"" Now I want to multiply that total by cell F27 and put the total in cell F28. Again, if the total is zero, I want the cell to be blank. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
Why the complicated formula?
=sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need to test for cells with data. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
On way:
=IF(IF(COUNT(F8:F26),SUM(F8:F26)*F27,"")=0,"",IF(C OUNT(F8:F26),SUM(F8:F26)*F27,"")) HTH, Paul -- "Vi" wrote in message ... I have added a column of numbers using the following formula so the total cell will be zero if there is nothing in the column: =IF(count(F8:F26),SUM(F8:F26),"" Now I want to multiply that total by cell F27 and put the total in cell F28. Again, if the total is zero, I want the cell to be blank. Please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
I don't want the zero to show up because it is on a form that we print out
and some people fill it out by hand instead of on the computer. "HKaplan" wrote: Why the complicated formula? =sum(F8:F26) will return 0 if F8:F26 is empty anyway. You don't need to test for cells with data. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
Go to Tools | Options, and uncheck the zero values in the View tab.
Then zero values will all be blank. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
This did not work - it did not give me an answer at all when there was
something in the column. "Vi" wrote: I have added a column of numbers using the following formula so the total cell will be zero if there is nothing in the column: =IF(count(F8:F26),SUM(F8:F26),"" Now I want to multiply that total by cell F27 and put the total in cell F28. Again, if the total is zero, I want the cell to be blank. Please help |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
Try simplifying the formula as I suggested, leaving out the count
statement. =sum(A1:A20) is all you need to total a column. If the answer is zero, then the cell will be blank. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition & multiplication formula
You'll need to tell us what non-standard settings you are using. By
default, that would return zero. Perhaps you have display of zeroes suppressed? -- David Biddulph "HKaplan" wrote in message ... Try simplifying the formula as I suggested, leaving out the count statement. =sum(A1:A20) is all you need to total a column. If the answer is zero, then the cell will be blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addition help to edit a formula | Excel Worksheet Functions | |||
Vlookup and Multiplication formula | Excel Discussion (Misc queries) | |||
Whatsthe formula which retrieves a # from a multiplication table | Excel Worksheet Functions | |||
one formula to make a multiplication table work | Excel Worksheet Functions | |||
Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions |