View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default plz help in to creat formula of excel

Thanks RD

Saves typing a couple of {}


Gord

On Sun, 4 Dec 2005 11:05:11 -0800, "Ragdyer" wrote:

And to add to your nice idea Gord, we can make it a single array constant,
instead of 2.<g

=LOOKUP(A1,{1,53,60,68,70,76,80;1,1.3,2,2.8,3,3.6 ,4})