HI Guys,

Great Site, Could someone help to provide for the formula for cal of stamp duty in excel .

The conditions are as such :

First $180,000 @ 1%

Next $180,000 @ 2%

Balance amount @ 3%

I want to be able to just key in the purchase price and the stamp duty amount will show.

Many thanks in advance.

Newbie

Great Site, Could someone help to provide for the formula for cal of stamp duty in excel .

The conditions are as such :

First $180,000 @ 1%

Next $180,000 @ 2%

Balance amount @ 3%

I want to be able to just key in the purchase price and the stamp duty amount will show.

Many thanks in advance.

Newbie

- Stamp Duty
- Formula for calculating # of days between 2 cells
- Formula for calculating # of days between 2 cells
- Formula for Calculating (Accrual) Off Time (PTO)
- FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS
- Including formula for RSD in Excel
- Need formula for calculating hours in timesheet
- Excel help - Calculating Stamp Duty
- Formula for calculating no of days worked
- Formula for calculating tiered pricing
- Formula for calculating fixed monthly accruals by prorating based on start date
- Formula for calculating Variance
- Need help w/formula for calculating overtime hours
- Which formula is correct for calculating times?
- Formula For Calculating %
- Need help w/formula for calculating overtime hours
- Formula for Calculating Vacation Time Based on Anniversary AND Hours Worked
- Formula for Calculating Forward Weeks Cover....
- Formula for calculating Variance
- Need math formula for calculating purchase price
- Formula for 1 of 3 conditions
- Formula for Calculating List Price using Discount Percentage and Net Price
- Formula for running average while omitting blanks
- Formula for average of cells that have blanks

follows for Excel 2000. Below CELL is the value of the property purchased

i.e Â£310000

If CELL value < 250000 then answer = 1% of CELL value

If CELL value =>250000 and <500000 then answer = 3% of CELL value

If CELL value >500000 then answer = 4% of CELL value

In the above example where CELL = 310000 the answer should be 9300

Thanks for your help

examples that might be closest to my needs..

Need the exact formula for the following:

If A1= 3/1/2005 and A2=3/20/2005 I need A3 to equal the # of business days

between A1 & A2.

examples that might be closest to my needs..

Need the exact formula for the following:

If A1= 3/1/2005 and A2=3/20/2005 I need A3 to equal the # of business days

between A1 & A2.

I need to develop a tracking spreadsheet (for 18 employees) that will calculate accruing vacation time (on one worksheet) based on the following parameters:

Employees who have worked less than 1 year with the company:

- 10 days

Employees who have worked at least 1 year with the company:

- 12 days

Employees who have worked at least 2 year with the company:

- 13 days

Employees who have worked at least 3 year with the company:

- 14 days

Employees who have worked at least 4 year with the company:

- 15 days

Employees who have worked at least 5 year+ with the company:

- each year will add 1 day until reach the max 20 days

In addition I need to be able to deduct vacation time used. Does anyone have any suggestions for layout or for a formula that can do part of these functions? I appreciate any advice!

The formula for calculation of RSD is =(Std deviation X 100)/Average values.

I want to know is it possible to include the above formula in Excel 2007 (as function key). So that by selecting single function i can calculate the values.

In my example (attached), you can see that the hours for 1/20 are over 8 hours, and 10 hours is showing in the "Total Regular Hours" column. I would like for all hours entered in this column to stop at 8, and any hours over 8 would show in the "Total Overtime Hours" column. (In this case, there should be an '8' in the "Total Regular Hours" column and a '2' in the "Total Overtime Hours" column.)

I've tried a few different options, but I can't figure out what the formula would be to achieve this result. Any help would be greatly appreciated!Timesheet Worksheet.xls

As a novice to excel, this is a great forum. Thanks everyone!

I was hoping someone could help me with the following:

1) Calculating Stamp Duty

Please see attached jpeg of Stamp Duty rates for sales of property in Hong Kong. Stamp Duty is based on the "consideration" or purchase price of the property.

I tried to create a formula by using nested IF functions but couldn't finish it because of the 7 nested formula limit. How could I go about solving this in a neat, clean manner?

Essentially, I want to be able to input the purchase price and have it automatically output the relevant Stamp Duty.

Thanks for your help!

Excel Amateur

I need to create a formula that calculates the number of days a person has worked within a quarter, if they have also left the organisation within the same quarter.

For example, I have someone who left on 26/08/08. I need to establish how many working days this person actually worked within the quarter (01/07/08 - 30/09/08). I need to do this for a large number of staff, so would appreciate it if anybody can let me know whether there is a formula that would calculate this.

Many thanks!!

Fee is 1.00% of amount up to 1,000,000. The next 4,000,000 (ie 1,000,001 million thru 5 million) is charged at 0.70%, and the amounts over 5 million are charged at 0.60%.

So, for example if the figure is 8,000,000 then the fee would be:

1,000,000 at 1.00% = 10,000

4,000,000 at 0.70% = 28,000

3,000,000 at 0.60% = 18,000

Total 56,000

I want to write a formula that will reference an input cell such that if I input 8,000,000, the formula will calculate $56,000.

I have tried to do it with an IF formula and just can't make it work.

I'm trying to calculate a monthly leave accrual formula for staff on a monthwise table.

In the sample file attached, John has joined on 01-NOV-2010 so his leave accrual will start from Nov @ 2.5 per month. But I would like to have a formula that returns accrual as zero for the months prior to his joining.

Similarly, Mary has joined on 15-Dec-2010 so in the joining month of Dec2010 her leave accrual will be (2.5/31 x 17 days of service in Dec) and for the following months it will be 2.5 per month

Like Ali, who joined on 17-Feb-2011 wil have the zero accruals till the month of Jan and in Feb it will be (2.5/28 x 12days of service in Feb )

I hope the sample is clear. Any remote soultions to build on will be helpful.

Thanks

between planned miles and actual miles driven by drivers at several

different locations. I am given the miles per location daily. I need

to calculate weekly percentage per location. Then YTD percentage per

local, then total for all locals, then YTD for all locals. Can someone

help me?

--

Lori Lynn

------------------------------------------------------------------------

Lori Lynn's Profile: http://www.excelforum.com/member.php...o&userid=25565

View this thread: http://www.excelforum.com/showthread...hreadid=389974

data is entered. I am entering time "in" and "out" two times (first half of

day total, then second half of day total, after meal break) and then i have a

formula which calculates those totals. In algebraic terms, say: a+b=c, then

for the second half of the day: d+e=f. then c+f=h, to give total hours

worked. what i need to have is a formula that calculates a new cell (say,

"i") so that IF h is greater than or equal to a value of 8.0 (hours per day),

then it automatically calculates the amount of hours over 8.0, keeping the

regular hours worked 8.0 in cell "h", and calculating the overtime hours as

anything over 8.0 into new cell, "i". hope that makes sense? can anyone

help me? thank you!!!

=IF(N31>O31,MIN(("24:00"-N31+O31)*24,7.25),MIN((O31-N31)*24,7.25))

and

=IF(N32>O32,CEILING(("24:00"-N32+O32),7.25),MIN((O32-N32)*24,7.25))

where N and O are the start & finsh times respectively.

Both seem to calculate properly, but does anyone know which is the better formula to use...of does it matter ? Thanks.

I'm new to the forum and not too hot with Excel either so please be patient with me.

I am after advise on creating a formula for creating percentages.

Basically this is for a chemicals spreadsheet.

What I have is a chemical - lets call it Chem 1

This will be made up from various raw materials so for maybe this example it's made up of 2 raws - let's say Raw 1 which is 60% of the finished product and Raw 2 which is 40%

So, what i need to be able to do is to enter into a cell my total order for Chem 1 in kg's, say 200kg and have it calculate into two seperate cells for the raws, how much i'm using of each raw (in this case 120kg & 80kg) and then to deduct it from a stock which would be pre-determined.

So, thank you very much indeed in advance for your help - hopefully the above makes sense.

Kind regards

Ian

data is entered. I am entering time "in" and "out" two times (first half of

day total, then second half of day total, after meal break) and then i have a

formula which calculates those totals. In algebraic terms, say: a+b=c, then

for the second half of the day: d+e=f. then c+f=h, to give total hours

worked. what i need to have is a formula that calculates a new cell (say,

"i") so that IF h is greater than or equal to a value of 8.0 (hours per day),

then it automatically calculates the amount of hours over 8.0, keeping the

regular hours worked 8.0 in cell "h", and calculating the overtime hours as

anything over 8.0 into new cell, "i". hope that makes sense? can anyone

help me? thank you!!!

I finally figured out the formula to calculate vacation time based on anniversary date for full-time employees.

Now, within the same sheet, I need to calculate vacation time based on anniversary date AND hours worked for part-time employees.

Here is the criteria:

0-3 years of service 1 hour for each 20 hours worked with a maximum of 4 hours

3-15 years of service 1 hour for each 13 hours worked with a maximum of 6 hours

15+ years of service 1 hour for each 20 hours worked with a maximum of 8 hours

Example: A part-time employee works 50 hours per pay period and his start date was 8/25/2002. Manually calculating, he would earn 3.8 biweekly

A part-time employee works 32 hours per pay period and his start date was 6/19/2011. He would earn 1.6 biweekly

Thanks!

Can someone guide me on how to use a formula to calculate the forward weeks cover (i.e. how many forward weeks cogs can fit into the month end inventory position).

Hopefully I've explained myself correctly.

Thanks in advance.

Thanks in advance!

I'm trying to write a formula to test for 1 of 3 conditions

If condition is true, return whichever part is true otherwise 0.

Formula:

VB:(FIND("Service Charge",$F2),"Service Charge",0))))If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

=AVERAGE(OFFSET(INDEX($C4:$AE4,,COUNT($C$4:$AE$4)),,-2,1,3))

Where data exists in 23 columns (C through AE) of row 4. It calculates the average using only the last 3 entries. this is only the case if data is filled in every column.

I am looking for a formula to accomplish the same thing. Automatically calculate a running average using the last 3 entries. However, the row of data I am using doesn't always contain entries in every column. An example:

Columns A-H contain the following (B=Blanks)

33B5B7B6

I am looking for (5+7+6)/3 = 6, but on a running basis (as the next number is added, the value in D (5) would be dropped. The formula listed above returns and answer of 5 when applied to the data set above.

have sum formulas. Some of the cells are blank due to no data being entered

in the sum cells. It is a monthly tally sheet so instead of getting the

average for May 1st thru May 13th, I am getting the average of May 1st thru

May 31st causing a lower total average.

My current formula for average is

=AVERAGE(T10:T40)

And it is figuring the average of cells that have this formula that is blank

=Sheet1!N21+Sheet1!N68

Any suggestions?