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 |
Thread Tools | |
Display Modes | |
|
|