Ask Your Question

All functions return result of ###

asked 2017-02-20 16:01:54 +0100

Fen gravatar image

Any function that I use returns a result of ###. For example, just as test, I entered 1,2,3 in cells and =SUM(F9:F11) below. It returns ###. This is the same result if I use AVERAGE, MEDIAN , etc. What am I missing? I did a format check and the source cells and function cells are set to numbers .

Thanks! Fen

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-02-20 16:04:08 +0100

Looks like your columns are too narrow for the output. Try to make them wider, or choose smaller font.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-20 16:01:54 +0100

Seen: 91 times

Last updated: Feb 20 '17