# Percentages With Negative Goals?

Feb 4, 2014
I need to get a percentage, whether it is negative or positive or 100% of goal for column E (for ie. Chardonnay would be +168%; CS would be -61%). Everything I have tried from previous posts just brings me to a % sign in column E with no number.

Shipment Goals thru January

%

Actual Shipments YTD

(+/-) Percent of Goal(Col E)

Cases Needed to Order

Chardonnay

0

100%

168

[code]....

View 3 Replies
ADVERTISEMENT
Feb 27, 2014

I have to calculate percentages, lots of them,, have 4 scenarios

1.- positive / positive

2.- positive / negative

3.- negative / positive

4.- negative / negative

I wish to find a formula that covers all scenarios, have thousands of data to calculate

View 2 Replies
View Related
Dec 15, 2009

I've hit a wall for the first time in my excel using career, I’ve searched the net high and low, asked the guys in my IT department and am so far stumped for a solution.

The problem is thus:

I have 3 columns, A, B and C.

Column A and B contain two numbers. Column A is "telephone calls offered" Column B is "Telephone calls Answered".

Column C is a calculation of the percentage of calls NOT answered. The formula I am using for this is =(A1-B1)/A1*1

This gives me a % as an answer.

Rows 1 to 66 are different time periods through out the day.

The problem is that for some fields, we don’t receive any calls, at all. Or we receive a call in one time period, and it is answered in another.

so Lets say cell A1 is 0, and Cell B2 is 3. Or A2 is 0 and B2 is 0.

How is it possible to get excel to display 0% if, after the calculation the value is < or = to Zero?

I have tried the below "IF" function but it returns a #Value error

=IF((A1-B1)/A*1<=0,"0%",(D67-E67)/D67*1)

I now leave it to the capable hands of the anonymous internet gods of excel

View 2 Replies
View Related
Aug 17, 2014

Following link explains how can format negative percentages.

[URL]....

Following code makes negative percentages red, positive percentages green.

[Code].....

I want to make; negative percentages red, positive percentages green, zero percentages blue, ---------->This is my question.

Attached File : Color Format.xlsm

View 3 Replies
View Related
Jun 27, 2014

I need a formula to create the following:

In Cell F5 is 26, so the percentage should be 101% (100+1). How can I modify the below to add 1% when the number goes over 100%?

Do I have to create two columns? one for the below and one if the F6 is over 100%?

IF(F6="N/A","N/A",IF(F6>=25,1,IF(F6>=19,0.8,IF(F6>=13,0.6,IF(F6>=7,0.4,IF(F6>=1,0.2,IF(F6

View 5 Replies
View Related
Feb 21, 2009

how can i get excel to read column c and return the answer into column f i have scores in column c that look like eg. 2-2 what i need excel to do is count the goals

in the example obviously 4 and then in column f if its over 2.5 return the value over but if its under 2.5 it returns under is this possible please given the format of column c?

View 14 Replies
View Related
Oct 22, 2013

I have goal table on table A and i want it data fill to tabel B with constant sum. maybe like sudoku in sum right and sum down.

View 1 Replies
View Related
Feb 25, 2014

Instead of having the goals and objectives already in the form I would like to have buttons that would allow my clinicians to add as many goals and objectives as they'd like to the attached treatment plan. I'd like them to be able to click a delete button as well when they review the plan and need to delete a goal that's been met. When my team clicks into the second worksheet they would see rows 10-16 (below). They would then type a STG 1 and an Obj A. They then would click the Add Obj button and add as many objectives that they needed. Then when they clicked the add goal button a blank copy of rows 10-16 (including the Add Obj button) would pasted one row down and would update to read STG 2. Neither of these buttons would appear when the document printed.

Here is a screen scrape of what I'd like the attached form to look like before goals and objectives are added.

add goal.jpg

The original form is saved in an .xltm format but I saved it in an .xlsm format so I could upload it here.

HCT ITP (2-25-14) Abbr.xlsm

I found a thread on this forum that came close to answering my question but my attempts to pull out the coding that I needed was unsuccessful. Here's a link to the thread: [URL] ........

View 14 Replies
View Related
May 12, 2009

I have a large dataset (24000 rows) that requires me to multiply two different columns of integers. In some cases, the two integers are both negative and multiplying them results in a product that is positive. I actually need that product to be negative rather than positive. I can't quite seem to figure out the best way to accomplish this.

View 5 Replies
View Related
Aug 1, 2007

I have data that comes from a subsytem that places the negative sign at the right of the number, so it is recognized as text. I can get around this using find and replace and then a second step to multiply that by -1, but is there a formula that can do this for me?

I was trying if(right(A1,1)="-",TBD,A1)

View 4 Replies
View Related
Sep 1, 2007

I have data starting in E7. I want it to go down the column and find the negative numbers. If it finds one then I want it to change the number in the row to the left of it to a negative. So if E67 is a negative number, make D67 a negative and so forth down the line Sounds "simple" but how do I do it?

View 7 Replies
View Related
Jan 19, 2009

I have data in range J2:J365 , H368:H401 & J403:J827. i want to check wether this range have negative values or not if yes load all negative values in the listbox1 by clicking checkbox.

View 3 Replies
View Related
Jul 20, 2009

I am working with a list and would like to show the top 10 careers in %.

Out of 914 votes __ % are interested in Nursing, __ % are interested in ABC, ___ % DEF, etc.

View 2 Replies
View Related
Dec 4, 2009

i have a figure of 395.00 euros to start and need to calculat percentages when i enter a certain figure ...

View 8 Replies
View Related
Mar 10, 2009

I think a really easy no brianer, I need to find the difference in percentage terms of two values. I am using =(B2-A2)/ABS(A2)

where B2 = 24.09

and A2 = 21.08

View 2 Replies
View Related
Oct 15, 2009

I am monitoring the balance in my Allocated Pension fund, via the WWW.

In particular, I am recording the profits (disregarding costs, outflows, etc.) as ANNUALISED PERCENTAGES (a new line, for each week).

My formula is:

=(accumulated profits/principal)*(365/elapsed days)

Questions:

Will my formula remain valid, when “elapsed days” exceed 365?

If not, is there a FUNCTION that can handle my problem. And

What would the function’s ARGUMENTS be?

View 3 Replies
View Related
Jul 26, 2006

I'm sure this will be an easy calculation for most of you...........

If I have two numbers, ie. 390 and 217, how can I calculate the difference

between the two figures as a percentage? (These two figures represent sales

in two months and I need to know the difference in percentage terms).

View 10 Replies
View Related
Mar 14, 2012

I would like a way to use conditional formatting to highlight percentages that are over 50%. The problem is that I have other numbers in the same column that are not percentages but I would like to ignore them for highlighting purposes? Can this be done without sorting the columns?

eg.

345- ignore

Ken- ignore

2500- ignore

45.6%- do not highlight

65- ignore

92%- highlight

View 5 Replies
View Related
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
Jul 2, 2007

Am trying to do a formula to work out a percentage of one figure from another, cannot for the life of me think it through properly!

So in

Cell J73 I have the net income and in cells J75 +J77 I have the total outgoings.

I want a formula that works out the percentage outgoings, so if someone is earning £100 and they have £20 outgoings, that is 20% of their earnings.

View 9 Replies
View Related
Jan 4, 2008

I am trying to combine to cells containing percentages, however when I do the percentages turn into decimals. I have tried using the text funtion, but that just returns the full number 1, no decimals or percentages.

View 9 Replies
View Related
Mar 2, 2008

I work at a library and have been asked for help by the Asst. Director. The problem is, I have next to no Excel experience, just what I've been reading in the Help files and Online.

We are using Excel 2003 and running XP. Here is his predicament: he has an excel document that lists the books we have ordered from a publisher. Column I has the MSRP for the book and Column J has the discounted price for the book. We are trying to get Column L to show the percentage of the discount that we received. This is what i've come up with:

example for line 255 typed in as formula for L: =1-7.95/14.98

It comes out correct when I type in the formula as I show above, but when I try typing in the formula (as it should look:=1-J255/I255) , i get an error message: #VALUE! ...

View 9 Replies
View Related
Jun 17, 2008

I have a table of data with names across the top and number of weeks down the left. The table lists amounts of money those names earned during the respective weeks. It looks something like this:

Mike Dan Bill Carl

400 500 600 700

800 900 1000 800

700 600 500 400

In a seperate worksheet within the same workbook, I have 3 columns of data. The first column is a name. The second column is a criteria. In the third column, I am trying to look up the value of 8 specified weeks of earnings of the name I put in column 1 and multiply those earnings by a percentage based on the criteria in column 2. Then sum the products.

I have a table of the 8 percentages I am trying to apply. There are 7 different percentage applications.

So if I am looking up Mike's earnings during those 8 specified weeks and the criteria in column 2 is "B", then I want to apply the appropriate column of percentages to those 8 looked up earnings, Multply them and then Add them.

Up until now, I have been trying to use some hybrid of HLOOKUP, SUMPRODUCT, and IF.

View 9 Replies
View Related
Aug 20, 2008

I have a column of data with students marks ranging from zero to 78(S17:S74). I need to work out the mean score of the bottom 20% of all the scores achieved - Is this possible. I'm no expert so please keep it as simple as possible! I'm working with Windows XP and Excel 2002.

View 9 Replies
View Related
Sep 16, 2009

I have data that I import from another source into excel and it pulls over like this

3866.00%

435.00%

125.00%

1254.00%

I want to remove the % since these aren't actually percentages, the report we pull from has them listed incorrectly and cannot be changed since it is software driven, not excel driven. The problem is simply remove the % changes the number to 38.66 instead of leaving it at 3866.

View 9 Replies
View Related
Jun 24, 2006

I have a row of formulas that calculates information into a percentage. As you input info, a percentage is created in the cell. Those cells that do not yet have information entered still show " DIV/0" or something like that.

I need a formula that will average all the percentages, but the problem is, it's trying to also average the formulas with the percentages, so I currently get an error.

View 9 Replies
View Related
Jun 25, 2006

I am using an excel loan amortization schedule but I need to add another cell to calculate percentages. how do I do this? I need to know the command.

View 2 Replies
View Related
Apr 4, 2014

Input cell: a number from 1 - 100

Output cell:

If input is 1, output is 5.5%

add 0.5% until 10.

add 1% from 11 - 20

add 1.5% from 21-30

add 2% from 31-40

keep adding 0.5% every 10, until 100

100 = 280%

View 1 Replies
View Related
Aug 12, 2014

I want to show values entered with percentage sign.(%) Right now, if i enter any value say,10 in a cell having percentage format, shows 1000%. For that, I don't want to enter 0.1. I just want to enter any value and see it with percentage symbol.

View 4 Replies
View Related
Sep 29, 2009

How do I round percentages, both up and down, to the nearest 5%?

Ex. 82% to 80% as well as 84% to 85%

View 4 Replies
View Related