$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Hi Prasad, Please find the attached excel. I just tried ,don't know whether its correct or not Please have a look. Regards, Sreevijay 2009/8/18 Prasad Gadgil > > *Dear All, > > **Case: *There are four different rate cards (A,B,C,D) & now i have to > calculate the brokerage depending upon rat

Fw: $$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

- Original Message - From: Sandeep To: excel-macros@googlegroups.com Sent: Friday, August 21, 2009 8:42 AM Subject: Re: $$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula Please find the attach file with all of you need Sandeep - Original Message - From

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Please find the attach file with all of you need Sandeep - Original Message - From: Swapnil Palande To: excel-macros@googlegroups.com Sent: Thursday, August 20, 2009 7:47 PM Subject: $$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula Hi Dharmesh, You can

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Hi Dharmesh, You can create UDF in Visual Basic Editor. You can see the code in VBE. Go to Tools --> Macro ---> Visual Basic Editor At the left side of VBE you will get the list of VBA project. This list shows all the excels currently open. If you want to see the UDF I have written for RateTabl

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Hi Swapnil Can u explain how to create userdifined function. or where to see that function. Regards Dharmesh Shah On Wed, Aug 19, 2009 at 6:56 PM, Swapnil Palande wrote: > Hi Prasad, > > Please find attached excel for solution. > > I have write user define function for this. > > You have to us

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Dear Prasad I have checked your file, i think your rate slabs are as mentioned in blue shaded area in attached file and if yes then in green area u can find the solution, if ur requirement is not fulfilled I can help u further REHAN BAIG On 8/19/09, MOKSH.. wrote: > > > > 2009/8/18 Pra

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Hi Prasad, Please find attached excel for solution. I have write user define function for this. You have to use following formula to calculate rate: =calcRate(A3, C3) In above formula first parameter is type of rate and second parameter is value. You can use If condition also to solve this prob

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

2009/8/18 Prasad Gadgil > > *Dear All, > > **Case: *There are four different rate cards (A,B,C,D) & now i have to > calculate the brokerage depending upon rate type mentioned in previous > column. > > *Resoulation :* I need an formula, which will pickup the rate based on > type mentioned in the c