OFFSET formula won't execute..whats the unique keystroke to get it to work?

[Marq]

I have an offset formula that is enclosed by { }

Isn't there some kind of keystroke I have to hit to make it to work? Isnt the keystroke called "validating"??

The formula works perfect in another work book and I tried copying and pasting but it isnt copying. I then wrote the formula, changing the cell locations to fit this new workbook but the formula shows up as text in the cell.

I am putting the formula in A38, a date will go in K36....and I will populate K38 through IV38 with values as time goes on.

=OFFSET($A$36,0,MIN(IF($K38:IV38>0,COLUMN($K$36:$IV$36)-1)))

isnt it CONTROL/SHIFT/ENTER ??

Im doing it and the value of the cell is showing the formula

 

[Norie]

Try entering the formula, without the {}, using CTRL+SHIFT+ENTER.

 

[Fluff]

If you see the formula in the cell, either you have selected "show formulas" on the formula tab, or the cell is formatted as text.

 

[Marq]

Try entering the formula, without the {}, using CTRL+SHIFT+ENTER.

aaahhh..thats what it was. I wasnt supposed to type the {}. Those show up AFTER you hit ctrl/shift/enter

I was simply typing the formula verbatim from the other work book

Thanks!