Difference in answers

[rfdryden]

the following formula:
=IF(B130<>"",MAXA(LEN('Data Sheet'!DY2:DY65536)),"")
produces the answer 6 in the formula palate.
it produces the answer 1 in the cell.
I am trying to determine the maximun width of a range of cells containing both numerical and text data.
Any Suggestions

 

[Aladin Akyurek]

On 2002-03-10 20:15, rfdryden wrote:
the following formula:
=IF(B130<>"",MAXA(LEN('Data Sheet'!DY2:DY65536)),"")
produces the answer 6 in the formula palate.
it produces the answer 1 in the cell.
I am trying to determine the maximun width of a range of cells containing both numerical and text data.
Any Suggestions

The formula builder evaluates your formula as an array formula and shows the result of applying MAXA on a constant array. If you want to get the same result as the formula builder, hit control+shift+enter at the same time - not just enter - to enter your formula. By the way, you are computing a max of lengths, so MAX instead of MAXA would be just as good and less confusing.