Calculate Net Pay After Tax

Feb 18, 2008

building a spreadsheet. I have the total price in cell f6. In cell C6 I need price with no taxes. D6 should be the pst of 8% and E6 should be the gst of 5%.

ADVERTISEMENT

Calculate The Value In The NPV

Aug 29, 2008

I have two columns in a payment schedule (which adjusts according to certain user inputs) that I need to use in my NPV calculation.

The first column is the Total Payment and the second is Inducements.

Therefore each value in the NPV calc. needs to be the sum of a given period's payment and inducement (but i don't want/have a separate column which calculates the sums). The number of periods adjusts with the users input of Term. There also may be periods where there is a payment but no inducement.

View 14 Replies View Related

Calculate Down To Last Row

Dec 22, 2011

The formula below calculates between rows 2 and 109. How can I change it to calculate between row 2 and the last used row in the sheet.

Code:
Range("D2").Select
ActiveCell.FormulaR1C1 = _
"=(RC[-1]-MIN(R1C[-1]:R109C[-1]))/(MAX(R1C[-1]:R109C[-1])-MIN(R1C[-1]:R109C[-1]))"

View 2 Replies View Related

Calculate IRR & NPV

Jan 10, 2007

i got a problem to calculate IRR and NPV for my company cash flow. i so confuse how to calculate cos the initial investment (expense) is pay in installment by yearly basis. i hope anyone can help me to solve this problem.

I m not sure whether what i'm doing is correct or not. thanx

http://spreadsheets.google.com/ccc?k...Hd2JSrIj7H-Pew

View 9 Replies View Related

Calculate How Many Of The Same Value In A Row?

Feb 17, 2007

If I have this serie of values in the A column:

34
33
33
33
30
29
26
26
20
19
17
17

And want this results in the B column:

1
3
3
3
1
1
2
2
1
1
2
2

Those numbers will indicate how many of the same are in a row.

What's the easiest way to accomplish this?

View 7 Replies View Related

How To Calculate Age

May 13, 2009

to calculate the age from the format date of birth shown below.

SQL Data S1Date of Birth2Jun 9 1947 12:00AM3Jan 1 1957 12:00AM4Jan 1 1958 12:00AM5Jan 1 1956 12:00AM6Jun 4 1951 12:00AM7Dec 10 1963 12:00AM8Jun 17 1958 12:00AM Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Sub Calculate

Feb 24, 2010

I am trying to call a sub calculate but I keep getting errors, is calculate a reserved sub name?

View 9 Replies View Related

Formula To Calculate GST

May 6, 2013

Formula to calculate GST? I have a Non-capital and a Capital column, then a Claimable GST column.

I currently have '=SUM(E5/11)' in the Claimable GST column (G5).

If E5 is a zero value I need the sum of F5/11 in G5.

View 2 Replies View Related

If Blank Do Not Calculate

May 16, 2014

I have the following scenario on the attached worksheet: I need b45 to say 0% if b42 and b43 are left blank.

View 3 Replies View Related

Calculate Percentage Of Value

Jun 21, 2014

I have a simple issue i cannot figure out how to write a formula for.

In A2 i have the number of operations.

In A4 i have the percentage of CPU usage it requires to complete those operations.

I need an output somewhere that will tell me how may operations I can get per 0.1% of CPU usage.

View 5 Replies View Related

Calculate Until Difference Is Zero

Jul 24, 2014

I'm trying to automate the attached schedule so that the formulas in H stop increasing once the amount in column J equals zero. So far everything I've tried either gives me a circular reference error or ends up giving me the same result as if I depreciated the asset an additional month.

View 3 Replies View Related

Formula To Calculate TAT?

Feb 22, 2014

I need to calculate a TAT formula for the below case

P1 -- 1 Hour
P2 -- 2 Hour
P3 -- 4 Hour
P4 -- 8 Hour

Shift Start time : 6:30pm
Shift End Time : 3:30am

Suppose a request comes at 9:30pm and it is Priority 1 (P1) then it should be completed at 9:30pm + 1 hour = 10:30pm. I have given the below formula to execute this

=IF(A2="P1",1,IF(A2="P2",2,IF(A2="P3",4,IF(A2="P4",8,0))))

=B2+(TIME(D2,0,0))

The problem here is if the request is P4 then its 8 hr TAT and the formula will calculate the time as 5:30am. Since the shift time end at 3:30am itself the actual TAT should be the next day 8:30pm.

formula to calculate the TAT which includes the start time and end time and also excludes the weekends and holidays.

View 14 Replies View Related

How To Calculate Overtime

Sep 5, 2008

I am trying to formulate a formula that will calculate overtime hours worked.
Now standard hours are 17:30pm - 20:45pm. Anything outside these hours are overtime. If the start time is 18:00pm then the person is still paid from 17:30pm @ standard rate regardless.

Now I am trying to work out a formula that will cover hrs outside of the standard hrs AND hrs unworked but paid for.

see attached! September tab {blue highlighted cells}

View 9 Replies View Related

Calculate The Date..

Feb 23, 2009

Is there a formula for calculating date for every 2nd thursday of the month excluding holidays?

View 4 Replies View Related

Calculate Variances

May 14, 2009

Just wanted to find out if the formulas in the attached apreadsheet are correct. Formulas from E6 to E10.

Also, if you multiply the "new daily target" with "working days" should'nt this give you the "remaining" figure? Currently it's not doing this

View 11 Replies View Related

Calculate The Hours

Jun 16, 2009

How to calculate the Hours
Check the attached file

View 5 Replies View Related

Calculate Retrospectively

Jul 14, 2009

I need to create a formula to work backwards from a closing balance to establish an inventory value on First In, First Out principles. The attached spreadsheet probably explains it better.

View 2 Replies View Related

Calculate Total

Aug 13, 2009

I need a formula that will calculate the total of the items in column "W" when the row directly below it contains a "1" in column "V". It will need to calculate the totals from that row all the way up to the next row that contains a "1" in column V.

Example:

In X14 (where I will put the formula) it would total W9 through W14. However the formula still needs to be able to calculate the total if there are more or less cells to sum. So that the same formula could calculate that in X8 it will total W5 through W8.

View 14 Replies View Related

Calculate A Certain Weekday

Oct 28, 2009

I need to set up something that "calculates" an orders next delivery date. We deliver on Tuesdays, Wednesdays, and Thursdays for different stores. IE.

Store 1 - Today's Date-Wednesday 10/28/09 = Next delivery date is Tuesday 11/3/09.
Store 2 - Today's Date-Wednesday 10/28/09 = Next delivery date is Wednesday 11/4/09.
Store 3 - Today's Date-Wednesday 10/28/09 = Next delivery date is Thursday 10/29/09.

View 3 Replies View Related

Formula To Calculate A %

Nov 2, 2009

I use this formula to calculate a %, but naturally when there is a 0 excel returns the #DIV/0! error. Can someone fix my formula so the error gets replaced with a 0
in the formula the 0 would be in cell W2 =IF(N2="yes",BN2/W2,0.5).

View 3 Replies View Related

Look For Text And Calculate

May 20, 2014

I have 2 columns (A and B) of text, A and B that needs to be turned into numbers in column C. The text in column A can also occur in column B and vice verse. There can also be 2 or 3 values in column B, there is no "," to separate the values only spaces. Every text name has a value (they are explained in the file but not included in original files). If there is text in both columns it has to add the value for each text. I need to get column C calculated by using VBA. Column C is empty from the start and the rows can be +500.

In the file the result is applied manually.

View 2 Replies View Related

Calculate The Percentage

Jan 26, 2009

I have attached a file with both a sample section of data on the first sheet and the outcome I would like on the second sheet... I would do it all manually but there are over 200,000 rows in the actual file.

The macro needs to calculate the percentage of sale for each reference number within each part number and move down to the next part number and do the same until it reaches the bottom.

View 9 Replies View Related

Calculate A Sheet Every Second

Feb 9, 2009

I am looking for a way to calculate a sheet every second. I haven't been able to find anything in the forums

View 2 Replies View Related

VBA Calculate Pause

Mar 16, 2009

Hi everyone I am having a little trouble with a sheet i'm currently working on. Having exhausted what i believe to be every avenue trying to do this without VBA, i've finally had to sucomb to it as i can't see an alternative and i'm no VB expert by any means! This is what i have so far:

View 7 Replies View Related

Calculate Button

Jul 4, 2009

I am trying to create a Radio button in a cell that calculates the entire workbook rather than pressing F9.

View 13 Replies View Related

Calculate Workbook

Sep 8, 2009

I'm opening 2 workbooks and I'm on Manual Calculation option. I wanted to calculate only workbook A. The standard button only give me the option of calculating a worksheet or all open workbooks (F9).

View 4 Replies View Related

Calculate Hours

Jan 9, 2007

I am designing a simple time card. Column D=time in, Column E=time out. My formula in column F to calculate total hours is =TEXT(E2-D2,"[h]hrs"). The result is not correct. Example: In at 9:30 out at 5:00 and the calculated total is -4 hours.

View 10 Replies View Related

Formula - How To Calculate For The 35 Min At Say 15.24

Dec 23, 2008

i just started with a company Royal Mail and they have some very strange timings for starting and finishing and i need a formula to help me work my money out and my hours to the precise min.

for example i have a shift comming up this week and my start time is down for 22:45 and my calculated finishing time is 07:23. i need a formula that will show on a spread sheet my exact time of work.

the other time i had was 22:35 to 06:35...it all seems prity simple to alot of people but this is my other problem. if i work from 06 - 18:00 i get one rate and if i work from 18 - 06:00 i get another rate.

so i need to know how to calculate for the 35 min at say 15.24 ph.

View 14 Replies View Related

Calculate Age In Months

Nov 9, 2009

I need to be able to calculate age in months, and round whatever remainder to the middle of the month (.5). I am calculating z-scores and percentiles for in a childhood obesity project. The DoB and Date of measurements must be converted to read anything from 142.0 to 142.9 as 142.5.

This value will be used to look up the the appropriate LMS (Box Cox, Median, and Standard Deviation) in another excel table. I have to be able to compute age in months so 142.5, 143.5, 144.5, 144.5 etc. It is just not rounding off to the nearest half month.

View 7 Replies View Related

Calculate A And B If C Filled?

Feb 25, 2012

Data:

20 25 a 30 35 b 40 45 c 50 55 d 60 65 e 70 75 f 80 85 g 90 95 h 100 105 i 110 115 j
"20" is cell a1 and "j" is cell c10

my question: how to divide column a and b if column c filled.

View 9 Replies View Related

How To Calculate New Customers

Apr 13, 2012

I am working on a project and I have a list of customers. I need to calculate how many customers we had in week 1, week 2 etc of year. This would allow me to draw a beautiful chart of our company. How would you calculate this? Here is some data:

ABCDEF1February 2, 2011
Week1232February 15, 2011
Customers???3March 15, 2011
4April 15, 2011
5April 15, 2011

[code].....

View 4 Replies View Related

Calculate Date With A Dot Instead Of Bar

Jul 3, 2012

I have a file that has filled me with dot '.' instead of bar '/'.

Would be possible to calculate dates in this format?

Data Firts
Date Last
Result

02.05.2012
03.05.2012
1

would then be a day as 'A2' - 'B2' = 1

View 6 Replies View Related

How To Calculate Every Different Way To Sum 100 From Certain Set Of Numbers

Mar 8, 2013

How to create scenarios where excel will select all the possible ways to sum your data set to a specific number?

Example:
Data Set: (20, 25, 18, 40, 23, 22, 73, 7, 38, 28, 52, 96, 4, 99,2)
Way to create: 100

Answer 1: 25, 73, 2
Answer 2: 38, 2, 40
Answer 3: 96, 4

Is there a function or data structure in order to complete this?

View 8 Replies View Related

VBA To Calculate New Variables?

Oct 7, 2013

I have a dataset that will be updated frequently and dumped into cells A1:D### that would look like:

ID Week Sales Rate
1 1 $200 3 0.5
1 2 $200 3 0.3
1 3 $200 3 0.2
1 4 $200 3 0.5
...

The formula i'd like to calculate in Column E Variable = "Forecast" Formula =IF(B2

View 2 Replies View Related

Calculate Max Value In Range

Oct 10, 2013

I have 2 values in columns A and B. they represent the row number. i need formula that will calculate Max value in range in column C from C(A value) to C(B value).

View 7 Replies View Related

How To Calculate Percentages

Nov 5, 2013

=IF(A2-B2,(B2/A2))

The simple formula above calculates percentage which basically in this example, 159-90 divded 159% which equals 56.60%. What i need the formula to recognize is if both the entries are 159 which should show 100%. Its to show error rates by the way. Percentage wise.

View 3 Replies View Related

Calculate Days Between X

Nov 12, 2013

I have a data set that looks like the following.

Description S M T W T F S
Item 1 X X
Item 2 X X

I have a few thousand rows of this. The X's could be placed in any column. I need to go through this data and determine the maximum days between X's for each row. I can't think of how to do something like this with either an equation or with VBA.

I can't get it to line up in the table above. But basically, there could be an X in Sunday and on Wednesday in one row. The next, could be every day of the week, the next could be any other combination. There could be 7 X's, 1 X, 3 X's, whatever.

View 1 Replies View Related

How To Calculate Mileage

Jun 23, 2014

trying to figure out a formula that would save me heaps of time trying to calculate mileage on expense reports each month, and I cannot for the life of me get the formula down. Following are the specifics:

Mileage is reimbursed at a rate of $0.17/mi for the first 198 miles in the week. Any mileage after 198 is calculated at a rate of $0.56/mi. The mileage log I have is a monthly log, and expenses are turned in on a monthly basis.

Is there a way to create a formula that will calculate on a weekly basis, at the correct rate based on the number of miles in that week thus far?

View 2 Replies View Related

How To Calculate Combinations ?

Nov 12, 2005

I want to see how much combinations are possible when i got 6 numbers..

-- got this numbers 1--2--3--4--5--6
-- want to calculate how much combinations of ( 2 ) numbers possible
-- want to calculate how much of ( 3 ) numbers possible
-- want to calculate how much of ( 4 ) numbers possible
-- want to calculate how much of ( 5) numbers possible

-- never 2 same numbers together (2-2) or (2-2-3) or (2-2-3-4) may not be in list

-- How can i make the result visible in kind of list ?


I would be nice if somebody knows a good solution..

View 9 Replies View Related

Formula To Calculate How Much Tax To Pay

Nov 25, 2006

Working from cell D19 I am trying to find a formula to calculate how much tax to pay.
I have a TAXABLE INCOME figure (in cell D18) , from this figure

The FIRST 1520 should be multiplied by 0.1 (in cell C19,)
The next 26880 should be multiplied by 0.22 (in cell C20, the answer to be put into D20)
Any remaining from the Taxable Income figure (put into cell C21), should be multiplied by 0.4 (the answer placed in cell D21)

View 9 Replies View Related

Calculate If There Is Anything In The Cell

Mar 6, 2007

Im wanting to do a sum calculate if there is anything in the cell.
Ive tried using the 'count' and 'count if' but both return values of zero.

There are words in the cell, rather than numbers.

I want it to return the value of cells with data in them, and exclude those with nothing ("") in them.

View 9 Replies View Related

ADVERTISEMENT