$$Excel-Macros$$ Calculation of Import Value

Dear Experts, I need a formula or function for calculation of Taxes in single cell. Value 1,000,000 Custom Duty 20% Sales Tax 16% x (Value+Custom Duty) Income Tax 6% x (Value+Custom Duty+Sales Tax) *Required Value (Custom Duty+Sales Tax+Income Tax)* Is there any single formula or function where

Re: $$Excel-Macros$$ Need formula to retrieve value

Dear Abhishek, Working fine Will yo please explain this how it works? On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote: > Check attached. Let us know if there is any further query. > > HTH > Abhi > > > On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrot

Re: $$Excel-Macros$$ Need formula to retrieve value

Check attached. Let us know if there is any further query. HTH Abhi On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma < rakeshks@gmail.com> wrote: > Dear Experts, > > I need a formula/function which can give required value. Sample file > attached. > > Thanks in Advance > > -- > Regar

Re: $$Excel-Macros$$ Offset Advanced Dynamic Ranges

Dear Sekar, Wow.that great Thank you so much, your assistance is greatly appreciated. This will be grt solution to this group members Also Anil ,I am Thankful for you for Noorian guide sheet Thanks a lot once again Sekar Best Regards, Amar On Tue, Feb 19, 2013 at 12:12 PM, R

$$Excel-Macros$$ Need formula to retrieve value

Dear Experts, I need a formula/function which can give required value. Sample file attached. Thanks in Advance -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Faceboo

Fwd: $$Excel-Macros$$ Formula for Loan amount

Brother I want to know about the formula with the data i had provided so pls give exact solution. -- Forwarded message -- From: pankaj sangotra Date: Tue, Feb 19, 2013 at 11:50 AM Subject: Re: $$Excel-Macros$$ Formula for Loan amount To: excel-macros@googlegroups.com Hello B

$$Excel-Macros$$ IF Doubt - Query

Hi group, I have a small query for solving IF Function.i want the the answer which is in between the two given values. Pls HelpThanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://w

Re: $$Excel-Macros$$ Need Excel Formula for Color Count

Dear ikhan, Pl find attached herewith. Warm Regards, Gawli Anil On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote: > Hi, > > Can anyone help me count cell by color? I have attached sheet which i need > to count all green color. > > regards, > Imran Khan > > -- > Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Formula for Loan amount

Hello Bro.. if u are using Excel 2007 it is bulid template named Loan Amortization.. To get this template : Go to Home page : New: Installed template and u will get what you are looking for .. Hope this is helpfull to U.. Enjoy ur day.. Thanks Pankaj Sangotra On Tue, Feb 19, 2013 at 6:09 AM,

$$Excel-Macros$$ Need Excel Formula for Color Count

Hi, Can anyone help me count cell by color? I have attached sheet which i need to count all green color. regards, Imran Khan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/

$$Excel-Macros$$ Formula for Loan amount

Dear All I want to Know about the formula to calculate the installment amount: If loan amount is : 10/- Years: 3Years Rate of Interest : 14.50% P.A. Mode of Insallment :Monthly. 1)What will be the installment amount . Pls suggest by formula 2) If we

Re: $$Excel-Macros$$ Offset Advanced Dynamic Ranges

Dear All Friends, Pls suggest anyone offset formula On Mon, Feb 18, 2013 at 1:39 PM, amar takale wrote: > Dear All Experts, > Can anybody suggest me OFFSET formula for min & max & I give detailed in > attached file > Help is must required > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$ Re: how to crack Excel VBA password

> > Edit an excel macro file - Try MS Office VBA Password Recovery program > which can helps to use recover VBA Password immediately. MS Office VBA > Password Recovery - VBA Password > RecoveryTool worked with whole Microsoft > Excel file versions as: 2013,

Re: $$Excel-Macros$$ Locking Particular Cells in Excel

Dear Prabakar, Pl find attached sheet . Warm Regards, Gawli Anil On Tue, Feb 19, 2013 at 10:07 AM, Prabhakar S H wrote: > Hi Experts, > > I am not able to lock the particular cell in excel. Please refer attached > file and help me to lock only the particuar cell which is marked in Yellow. > > R

$$Excel-Macros$$ Locking Particular Cells in Excel

Hi Experts, I am not able to lock the particular cell in excel. Please refer attached file and help me to lock only the particuar cell which is marked in Yellow. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

Hi Anton How are you calling this sub? You are probably calling it without specifying Target. You might need to start it like (untested) Private Sub Accounting_type2() Dim Target as range Set Target = ActiveSheet.ActiveCell Regards David Grugeon On 19 February 2013 00:58, Anton Jopko wr

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Your cell in yellow is not a formula. So you're saying you want to take the Month/day from B and C, the Year from D/E/F and calculate the number of days between the Start/End dates built from these combinations? Basically, you'd build the date for the ending date: =DATEVALUE(MONTH($C2)&"/"&DAY($

$$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Hello All, I am attaching a sample file for my problem. I wish to have a formula entered in Cell D2 (highlighted in yellow - *to be dragged across and down*) to calculate the number of days in Col D, E and F over different years from the Start and End Date. Thanks in advance Rashid Khan -- Are

Re: $$Excel-Macros$$ Dynamic Data Validation Issue *

Oh Thanks Ashish, you are a life saver. great. working excellently. On Mon, Feb 18, 2013 at 5:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Dynamic Data Validation Issue

try the attachment see if it helps On Mon, Feb 18, 2013 at 10:17 PM, Hilary Lomotey wrote: > Hello Gurus, > > Hope i find you well. i am faced with a slight challenge and i kindly ask > for ideas on this. The issue is in sheet one is my cashbook. under the > main ledger i have the 5 main cate

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

Cool Solution Rajan Regards Prince On Monday, February 18, 2013 1:15:48 PM UTC+5:30, Rajan_Verma wrote: > > *Hi Deepak* > > *See the attached Example,* > > * * > > *There are 4 set of data , I give name them like data 1 , data2 ,data3 > and data4 , then I insert a camera tool and reference them

Re: $$Excel-Macros$$ Hiding Sheet in Excel Workbook

Hi Prabhakar, Please follow the below steps. 1. Very hide the required Sheet, and protect VBA project with a password. (Not required but user can see which all the sheets are hidden. Just to avoid this) 2. Goto Protect Workbook and protect the STRUCTURE of the workbook with a different pass

$$Excel-Macros$$ Re: How to protect particular cell in excel

Hi Prabhakar, Please follow the below steps. 1. Select All Cells, goto Format Cells-Protection and uncheck Locked checkbox. 2. Again select particular cells which needs to be protected (ex: A1:D10), goto Format Cells-Protection and check Locked checkbox. 3. Now goto Protect Sheet and enter a pa

Fwd: $$Excel-Macros$$ how to get cumulative sum in a cell

Following message posted direct to Anton by mistake. It worked. Regards David Grugeon -- Forwarded message -- From: David Grugeon Date: 17 February 2013 07:16 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell To: anton Have a look at this link. The solution i

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

Oh Great, Deepak, it is the really very worth-full post by you. my hats off for explain this concept among excel user. I hope it will increase again more interest of user to see and review again each post of user group. Again Tussi great ho tohfa kabool karo On Mon, Feb 18, 2013 at 4:05 PM, De

$$Excel-Macros$$ Training PPT

Hi Friends, I need to develop a excel training ppt for one institute. Could you please suggest, what topics should be covered in Basic Excel Training & Advanced Excel Training. Regards, Deepak Bansal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ How to protect particular cell in excel

dear prabakar, Then u can use allow fields to edit . first protect the sheet and goto allow the fields to edit. Warm Regards, Gawli Anil On Mon, Feb 18, 2013 at 3:16 PM, Prabhakar S H wrote: > Hi Team, > > i want to protect particular in cell in excell without protecting the > entire sheet. Pl

$$Excel-Macros$$ How to protect particular cell in excel

Hi Team, i want to protect particular in cell in excell without protecting the entire sheet. Please give me solution to this query. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @