Solved: decimal columns: avareage function and blank entri... - Page 2

luisandres · 11-12-2022 12:06 PM

Hello, I am stuck, I have four columns of type decimal:

weighing 1 (ex. 1.1234 grams)
weigh-in 2
weigh-in 3
average weight

the average weight column has to average the three weigh-ins columns, but sometimes only 1 or 2 weigh-ins are entered.
the decimal form automatically enters a zero for me, giving me an erroneous average. How can i fix this?

TeeSee1

As a workaround, try..

([wt1]+[wt2]+[wt3])
/
(IF(ISBLANK([wt1]),0,1) + IF(ISBLANK([wt2]),0,1) + IF(ISBLANK([wt3]),0,1))

View solution in original post

decimal columns: avareage function and blank entries