Can someone explain why
=ROUND(F19 +0.15(F16-F15),0) is equal to F19 when (F16-F15) is equal to zero?
As a matter of fact I can replace 0.15 with any number (plus or minus) and the formula still gives F19 as the answer.
However, if I take the 0.15 out of the formula the result is 0 just as you would expect.
Bookmarks