entering forumla'

H

Harold

Ok here's a good one, I have a spreadsheet I am developing, it needs t
provide a minimum series. Unfortunately I have to put the series tota
for the rest of the year on this one rather than just copying the cel
week to week

I Went onto Cpearson. com and found what I was looking for, however i
did not work so I copied his example table and set it up as pe
instructionsm. then entered his example formula. Again it did no
work

I then copied the formula (using <control C> and pasted it into th
worksheet, WORKS PERFECTLY ?????

What am I doing wrong, I type the same formlua character by characte
into the spreadsheet one cell down and it does not work while I ca
copy the internet one on the wall and it will work

The two formula's are visually identical one works one doesent

I need to change the formula slightly (just the name of the range whic
I have already defined in the same way as the example) and it will no
ignore the zero.

I have tried copying the internet formlua into the series spot (when
do it works for the example list) and changing the names of the rang
using F2 but it still doesent work

if I could sign this I would sign it AHHHHHHHHHH


Thankyo
 
F

Frank Kabel

Hi
you may post the formula you have used :)
And Describe exactly what does not work
 
H

Harold

Its facinating this problem, if I take the following forumla and data

5
6
7
0



=MIN(IF(list<>0,list,FALSE)) copied off the website it works Perfectl
giving the result of 5

if I type it =MIN(IF(List<>0,List,FALSE)) straight into the workshee
it will give the result of 0 (which it shouldent)

if I take a formula that works and delete the L in false, the
immediately retype the L in exactly the same spot then press enter {n
change to the formula } it will give a result of zero

I eventually typed the series formula in word and copied into th
spreadsheet and it worked, what is the differece between copying in
forumla and typing it. Escpecially when simply deleting and retypin
one character kills the forumla.

Obvioulsy something is set wrong in my excell but what can it be thi
problem makes as much sense as a politician

thanks for reading the epics I't typing but I am totally perplexe
 
F

Frank Kabel

Hi
you have to enter these formulas as array formulas. That is hint
CTRL+SHIFT+ENTER instead of only ENTER after entering/chaning the
formula
 
Top