This is fairly difficult to explain.
I want a spreadsheet to calculate 50% of the total and then calculate 25% of that 50%. This should be output as the total amount discounted and then as the total payable in another cell.
For example, the total is £2500.00. 50% reduction is £1250.00. 25% of...
I'm looking to break down a total charge into monthly payments.
B2 contains the total charge
B3 contains the number of monthly payments
B5 contains the first instalment
B6 contains the remainder
This would be simple if the amounts were spread evenly, but I want to make sure that any pence are...
I need to create a spreadsheet to calculate the total of two or three cells depending on whether just two or all three contain data.
A3 contains an amount of money
B3 contains a number from 1-12
C3 contains another amount of money (if input)
The total in D3 will either be A3*B3 or A3*B3+C3...
I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total.
I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
what i want to do is.
i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week.
I have a spreadsheet
Q1 assessment criteria 1
Q1 assessment criteria 2
Q1 assessment criteria 2
Under Question 1 there are three things users have to report on their progress with. They type in the % figure and...
Hi! This seems like it should be pretty easy, but I can't get Excel to accept my formula. Maybe there's a better way to do what I am trying to do. There are two relevant tabs, "Total Summary" and "List." I am entering the formula on "Total Summary" to count items that meet specific criteria...
I have set up a timeline slicer on a pivot for a tool in Office 365. The users use Office 2013 and the pivot behaves exactly the same on both versions: if we put the slicer on today's date, we have the result of all the lines of today.
But we need more than that. In my version, if I double...
Can someone please help me with this:
I have a table with these columns:
Total 2016 in original currency
Total 2016 in CAD
Hi guys, little bit of an involved question here. The above is an example of my table for sales. I currently have two...
I have this formula below. I need to add and if statement to it that if the total is less than 4 (<4) then just put an 0 but if 4 or greater (>4) then show the number.
I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each sheet by using the ID No as the criteria.
Basically there is a column for 'Total' on...
At the moment I have this formula to total number of times a word appears in a given date range.
=COUNTIFS('Projects Tracker'!B20:B25000,">="&F8,'Projects Tracker'!B20:B25000,"<="&H8,'Projects Tracker'!F20:F25000, "*Sector: Corporate*")
F8 = Start Date
H8 = End date
B20:B25000 = List of...
New to spreadsheets. I have created a bi weekly time card based only on hours worked (no clock in clock out fields). I have 3 columns for hours (the actual time worked per day, O/T per day and Reg Hours per day with the O/T subtracted.
What I can't figure out how to do is create a code so if...
I want total sales for each sku in a specific date range. But what I get is daily sales excluding the daily sales that are not in the date range. So I then group the daily sales into years, so that I only get the total yearly sales for each item, and I get this.
The following code was taken from a macro I have been working on .... most of which is due to the help of people within this Forum... so thank you. Unfortunately, it takes over 60 seconds to run. I can't blame those who helped me in the past because I never conveyed the entire scope of the...
I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN>
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
I am battling to figure out how to make this easier. I need to take the data from a multi-page of "Comboboxs" and "Textboxs" to a specific sheet. I have code that works, but its going to be a lot of work and I have 2 tabs I have to do this for.
Private Sub CommandButton2_Click()...
I have a importsheet with data and need to extract and count several things from it, but I have no idea how or where to start (usually I only used Excel for math problem).
I made an exampelsheet with some fake imported data and the right nr of columns, the real importsheet contains...
Guys help me to make this code:
A company has 10 employees, they all get paid on hourly basis. For each employee the
company keeps h employee name, number of hours worked every week. Every employee
gets paid weekly. Gross earning is calculated by multiplying number of hours worked by