Free Microsoft Excel 2013 Quick Reference

Formula for calculation of stamp duty

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


Post your answer or comment

comments powered by Disqus
I am trying to write a formula to calculate the stamp duty in the UK as
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

Very simple. I work in a very busy and don't have time to read down on the
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.

Very simple. I work in a very busy and don't have time to read down on the
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.

Formula for Calculating (Accrual) Off Time (PTO)
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!

DOES ANY ONY HAVE THE FORMULA FOR CALCULATING MIN MAX LEVELS FOR INVENTORY
CONTROL

Dear Sir,
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.

I am putting together a time sheet, and I am trying to figure out a formula for calculating overtime hours. Anything over 8 hours is considered overtime, and I would like those hours to appear in a different cell.

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

Hello all,

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

Hi there

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!!

I am trying to write a formula that will calculate a price based upon a tiered pricing system. The tiering id this:

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.

Hi Guys,
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

I need help with formulas to calculate the percentage of variance
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

i am trying to create a timesheet that calculates cells automatically when
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 built a spreadsheet to calculate hours worked; I did it over a couple of weeks, reading and learning as I went. During the time I was doing this, somehow I ended up with 2 different formula for calculating hours worked...these are:

=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.

Hi folks,

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

i am trying to create a timesheet that calculates cells automatically when
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!!!

Hello,

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!

I need to calculate inventory forward weeks cover for the coming months. Based off of recent forecasts, I have the month end inventory positions and the Cost of Goods (cogs) by week also.

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.

I need help with formulas to calculate the percentage of variance 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?

I have a spreadsheet that calculates prices on a shopping list, such as price ea x quantity = purch price. I have some names for deals, such as B1G1F (buy one get one free), 50%, etc, which is factored into the formula for purchase price as needed. I am in need of a math formula (I can write out the formula in Excel) that would calculate a Buy One Get One 50% in BOTH a scenario with multiples of 2 quantity as well as a quantity of 1. The formula I have now works fine quantities of 2 and up. But if I have a quantity of 1 (there are reasons sometimes I need to use a 1 quantity), I am not getting the right answer. If I fix it to work on 1, it doesn't work on 2+. The basic math I'm using for the 2 and up is, (Quantity/2 x Price) + ((Quantity/2) x (Price/2)).

Thanks in advance!

Hi all

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


Hello, I have a net price (C4) from a supplier along with a percentage discount (D4) and want to calculate the starting list price. Can you help me with a formula for this? Thank you.

A search of the Mr.Excel archives turned up a formula for calculating the running average for a row of data by only averaging the last N entries. That formula is:

=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.

I am looking for the formula that would help me get an average of cells that
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?


No luck finding an answer? You could always try Google.