Excel Formula
=INT(SUM(A1:D1))
"grobertson" wrote:
Row A contains numbers either 1, 1.5, 2 or 3
At the end of the row is a formula to add up the numbers but I would like a
formula that adds them up but if there is 1.5 in the cell I want the formula
to think of it as 1 for example.
instead of 1, 1, 1, 1.5 = 4.5
I would like it to total 4
Is this possible
|