Ask Your Question

All functions return result of ### [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-25 01:37:17.621500

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 133 times

Last updated: Feb 20 '17