calculates

I'm building a spreadsheet for running the asset list, it calculates monthly depreciation and builds the accounts journal. Its under 1Mb of data. There are various formulas going on, simple SUM to SUMIFS but very few VLOOKUP. I entered a SUM to add up a column, the result was £0. ISNUMBER...

Hi Guys, I am trying to include another time slot for the formula I wrote with some digging online but now I am not sure how to change it to two slots. =(NETWORKDAYS(J3,K3,Holidays!$C$2:$C$50)-1)*($O$2-$N$2) +...

I need some help with a formula to calculate this, I think I need a sumif formula but I am not sure. I have a excel table that calculates costs of services. The table is called npss_quote. There is a totals column called "Price ex. GST". There is a drop down menu with 5 services and the...

Hi all, Need some help please. I'm working in a spread sheet that calculates an overall time based on weekly, monthly, quarterly, Bi-annual and yearly time allocation as below (Columns P-T Row9). <tbody> #EBF1DE[/URL] , align: center"]P #EBF1DE[/URL] , align: center"]Q #EBF1DE[/URL] ...

Hello Dear, I have used Icon Sets of Conditional Formatting for this range based on the criteria shown in the attached picture, but why 6 is amber while it's 60% and the criterion states >= 60% which should be green, doesn't the 6 equal 60%? (Max=10 and Min=1, 6/10=60%) similarly, while...

Hi, I'm new here and hopeful this posting follows all guidelines. I tried to search for this but was unsure what I was looking for. I have spreadsheet that is thousands of rows long. Every 7 rows contains: a total; and 6 rows of data that make up that total. I would like to add a column and...

I am trying to create a pivot table that pulls number of hours and hourly rate from two different data sources, and then calculates an extended amount. To illustrate, below is a sample data source: <tbody>#DAE7F5[/URL] "] A B C D 1 Name Type Hrs Rate. 2 Jane A 10 25 3 Jane B 20 25 4...

Hello I'm not quite sure how to explain it. I want a simple formula of payments, in this example $100 in 5 months means $20 a month. But I don't want to be adding formulas every time I change the months for example <tbody> Value 100 Months 5 1 2 3 4 5 6 7 8 9 10 11 12...