----- 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: 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 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 RateTable excel.
Then select VBAProject(RateTable) in the list --> now click on Module --> In
Module there is option Module1, double clicked on it, now you can see the code.
Regards,
Swapnil.
On Thu, Aug 20, 2009 at 12:40 PM, Dharmesh Shah <dharmeshsha...@gmail.com>
wrote:
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 <swapnilp1...@gmail.com>
wrote:
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 problem. But limitation of If
condition is that it will not take more than 7 conditions. So you can check
conditions for two types only i.e. A and B.
I have write If condition also in excel.
I hope this will solve your problem.
Regards,
Swapnil.
On Tue, Aug 18, 2009 at 11:39 PM, Prasad Gadgil <maocca1...@gmail.com>
wrote:
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 column.
Attaching the same file.
Humble requesting to all of you, to resolve my query.
Thanks & Regards
Prasad Gadgil
Cell: 9819442088
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
Rates Table BEST SOLUTION.xls
Description: MS-Excel spreadsheet
