Free Microsoft Excel 2013 Quick Reference

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.

- Need math formula for calculating purchase price
- Formula for calculating tiered pricing
- Formula for calculating price
- Formula for Calculating (Accrual) Off Time (PTO)
- Formula for calculating price
- Help with calculating sales price
- FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS
- Formula for Calculating Vacation Time Based on Anniversary AND Hours Worked
- Need formula for calculating hours in timesheet
- Formula for calculating Gross Profit with muktiple discounts
- VBA code for calculating total price without clearing the content
- How to calculate a price using goal seek?
- Formula For Calculating %
- Formula to work out price after discount
- Formula for running average while omitting blanks
- Formula for calculating Variance
- Which formula is correct for calculating times?
- Calculating Distance Using a Range of Properties
- Is there a formula for calculating dates 3 mos out
- Calculating Markup For Retail Price
- Formula for calculating Markup and Vat
- Formula for Calculating Forward Weeks Cover....
- Formula for calculating Variance
- Formula for calculating fixed monthly accruals by prorating based on start date

Thanks in advance!

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.

conditions

Items costing the Contractor $50 or less are marked up 100% witha

profit margin on the selling price of 50%

items costing 50.01 to 100 are marked up 80% with a profit margin on

selling price of 44.44%

items costing over 100 are marked up 60% with a profit margin on the

selling price of 37.50%

--

nander

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

nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156

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

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!

Items costing the Contractor $50 or less are marked up 100% witha profit margin on the selling price of 50%

items costing 50.01 to 100 are marked up 80% with a profit margin on selling price of 44.44%

items costing over 100 are marked up 60% with a profit margin on the selling price of 37.50%

Thanks

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!

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

price equal profit divided by sell price equal gross margin percentage.

$10 less 50% less 10% =$4.50. Sell for $12.50. $6.00 less

$4.50 =$1.50. $1.50/6.00 = 25% GP.

All of these figures are in cells of their own. Cannot get this to

calculate correcly.

Please help! Urgent

I am in the final stage guys, but the problem is When i use formula to calculate this, the contents will be cleared including the formula when i click on "New Invoice". i am looking for VBA code from the experts to calculate the "Total Price", by automatically taking the values of "Unit price" and "Quantity". I dont want to do this with any sorta formulas, I am only looking for the VB code, that helps fix this issue and I dont want to calculate the "Total Price" manually.

Find the Excel file that i am dealing with in the attachment...

Thanks in advance...

Thanks a lot for your help in advance

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

Need help with an excel formula to work out cost price for an item after applying a discount. I am only new to this so if anyone can help it would be much appriciated.

I have following cells which have the data I need to look at to get final cost.

E10 - Has cost price per meter before discount

D10 - Has size in meters of lenth of metal

F10 - Has discount figure (46%)

G16 - Is where I want discounted price to appear.

(I need a formula to multiply cost price x size of length of metal, minus the discount figure).

Tks Mike

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

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

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

For each county, I have to calculate the distance from the county centroid to each property and return the prices for the top 5 closest counties (where the distance is greater than 0). From there, I need to calculate a median on the prices.

I am using this formula for calculating the distance between two lats and lons:

In this example, the lat1, lon1 values would be coming from the centroid of the county, and the lat2, lon2 values would be the property (but I need to basically run this calculation on a range of properties).

What is the formula I would use for calculating dates 3 mos. out

ex.

April 17, 2006 July 17, 2006 October, 17, 2006

I am trying to figure out the formula for calculating retail price if I have the cost and margin (%)/

Example:

cost is $10.00 (known figure)

Markup is : 40% (known figure)

Retail should be: 16.66

Thanks JR

I am doing a list of selling prices for producrts which have the same ,markup. Basically I have done the cost price in 1 column and the markup and VAT rate in 2 seperate cells (so that I can change without changing all the formulas).

How can i do the formula to for example a cost price of €50.00 is marked up by 35% and Vat is added on it?

Thanks

Ian

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

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