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

Mike Kaganski gravatar image

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: 84 times

Last updated: Feb 20 '17