Ask Your Question
0

Why [simple addition] 11/12/17+120 = 120 ?

asked 2017-12-06 00:43:13 +0200

abi gravatar image

using formula: = (a1)+(b1). ?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-12-06 00:57:10 +0200

If you are doing integer math, then the answer (120.054) would round to 120. How many digits of resolution are you using?

edit flag offensive delete link more
0

answered 2017-12-06 01:33:24 +0200

librebel gravatar image

Hello @abi,

Apparently the value “11/12/17” in your cell A1 was not recognized as a Date in your locale.

– Try inputting your date as “11-12-17”

– Try setting the NumberFormat of cell A1 to a Date format “DD/MM/YY”

Then the outcome of A1 + B1 should be (date) “10-04-18”.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-06 00:43:13 +0200

Seen: 37 times

Last updated: Dec 06 '17