$$Excel-Macros$$ Re: slab conditions

2008-12-06 Thread H Upadhyay
On 12/4/08, Tom Jeffries <[EMAIL PROTECTED]> wrote: > > I am attaching a function (GetRate) that does what you describe. If you > have any questions let me know. > > Tom > > On Wed, Dec 3, 2008 at 11:25 AM, raghuveer kumar <[EMAIL PROTECTED]>wrote: > >> Hi, >> >> I had a small query. >> >> I had a

$$Excel-Macros$$ Re: slab conditions

2008-12-06 Thread Raghuveer
Dear Nagi, What do you mean raw data file? On Fri, Dec 5, 2008 at 6:53 PM, kondaveti <[EMAIL PROTECTED]> wrote: > Hi, > Could you please send me the raw data file? > Nagi > > > On Fri, Dec 5, 2008 at 6:44 PM, Raghuveer <[EMAIL PROTECTED]> wrote: > >> Dear dev, >> I used IF condition, but it work

$$Excel-Macros$$ Re: slab conditions

2008-12-05 Thread kondaveti
Hi, Could you please send me the raw data file? Nagi On Fri, Dec 5, 2008 at 6:44 PM, Raghuveer <[EMAIL PROTECTED]> wrote: > Dear dev, > I used IF condition, but it works upto only 6 or 8. > > I had a 100s of products and I have to pick up the rate from specified > list.(By using vlookup function

$$Excel-Macros$$ Re: slab conditions

2008-12-05 Thread Raghuveer
Dear dev, I used IF condition, but it works upto only 6 or 8. I had a 100s of products and I have to pick up the rate from specified list.(By using vlookup function). Any way thanks for response... Can you find any more good way.. Thanks Raghuveer --~--~-~--~~~---~

$$Excel-Macros$$ Re: slab conditions

2008-12-04 Thread Dev
Hi - You will have to define the slab range and the rate in separate columns. use IF() to identify the range and calculate. Hope this helps! -Dev On Dec 3, 10:25 am, "raghuveer kumar" <[EMAIL PROTECTED]> wrote: > Hi, > > I had a small query. > > I had a data like as given in below example. > >

$$Excel-Macros$$ Re: slab conditions

2008-12-04 Thread Tom Jeffries
I am attaching a function (GetRate) that does what you describe. If you have any questions let me know. Tom On Wed, Dec 3, 2008 at 11:25 AM, raghuveer kumar <[EMAIL PROTECTED]>wrote: > Hi, > > I had a small query. > > I had a data like as given in below example. > >product slab(units)