=IF(SUM(B14:B15)/2=0,"",Bround((SUM(B14:B15)/2),0)) hopefully this may help. This is what the formula looks like in excel. I have tried working with it but still getting a lot of errors. Still any help would be great. Also, not sure how it works. But using the help, I got this answer "
However, the IEEE 754 standard dictates that the number literal 0.045 be approximated to 0.0449999999999999. This approximation is closer to 0.04 than to 0.05. Therefore,
Round(0.045, 2)
returns 0.04"
Something using number literals.