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
|
|||
|
|||
hiding zero for a sum
i'll try to explain best i can....
i have 3 colums, first and second are put in and the third is the difference between them. then on the bottom, i have the averages. i know how to do the subtraction, but for the other rows below keep showing "0" even though and the averages are now correct. how can i keep that column to automatically show the difference without always having the zero there and not having to always put that function in that box. here is what i looks like # DATE COURSE SCORE PAR (+/-) 1 04/03/10 49 37 12 2 04/03/10 43 34 9 3 04/19/10 44 36 8 4 0 5 0 6 0 7 0 8 0 9 0 0 AVERAGE 45.33 35.67 1.38 |
#2
|
|||
|
|||
hiding zero for a sum
hi
the usual way of doing this is to use an if formula =if(C2-D2=0,"",C2-D2) copy down as far as needed. if there is no data in C or D then the cell with the if formula will show as blank. the average formulas will ignore the "blank" cells and calculate only on cells that show data. regards FSt1 "bb" wrote: i'll try to explain best i can.... i have 3 colums, first and second are put in and the third is the difference between them. then on the bottom, i have the averages. i know how to do the subtraction, but for the other rows below keep showing "0" even though and the averages are now correct. how can i keep that column to automatically show the difference without always having the zero there and not having to always put that function in that box. here is what i looks like # DATE COURSE SCORE PAR (+/-) 1 04/03/10 49 37 12 2 04/03/10 43 34 9 3 04/19/10 44 36 8 4 0 5 0 6 0 7 0 8 0 9 0 0 AVERAGE 45.33 35.67 1.38 |
#3
|
|||
|
|||
hiding zero for a sum
Another method is to untick the show 'zero in a cell' option.
Check out help in your version of Excel "bb" wrote: i'll try to explain best i can.... i have 3 colums, first and second are put in and the third is the difference between them. then on the bottom, i have the averages. i know how to do the subtraction, but for the other rows below keep showing "0" even though and the averages are now correct. how can i keep that column to automatically show the difference without always having the zero there and not having to always put that function in that box. here is what i looks like # DATE COURSE SCORE PAR (+/-) 1 04/03/10 49 37 12 2 04/03/10 43 34 9 3 04/19/10 44 36 8 4 0 5 0 6 0 7 0 8 0 9 0 0 AVERAGE 45.33 35.67 1.38 |
#4
|
|||
|
|||
hiding zero for a sum
hi
true but that wont stop the average formula from counting the zero in it average. regards FSt1 "Ron@Buy" wrote: Another method is to untick the show 'zero in a cell' option. Check out help in your version of Excel "bb" wrote: i'll try to explain best i can.... i have 3 colums, first and second are put in and the third is the difference between them. then on the bottom, i have the averages. i know how to do the subtraction, but for the other rows below keep showing "0" even though and the averages are now correct. how can i keep that column to automatically show the difference without always having the zero there and not having to always put that function in that box. here is what i looks like # DATE COURSE SCORE PAR (+/-) 1 04/03/10 49 37 12 2 04/03/10 43 34 9 3 04/19/10 44 36 8 4 0 5 0 6 0 7 0 8 0 9 0 0 AVERAGE 45.33 35.67 1.38 |
Thread Tools | |
Display Modes | |
|
|