I want to be able to create a forumla to increase or decrease the percentage of a whole number i.e. Nett: 81.47 increase by 15% to give me the total and vice versa 92.27 decrease by 15% (I can do this on the calculator). Formula NOT reliant on other cells. Appreciate your help

0 |

2/18/2010 12:35:01 PM

Hi, in the cell where you want the result enter to increase =A1*1.15 to decrease =A1/1.15 "Shevvie" wrote: > I want to be able to create a forumla to increase or decrease the percentage > of a whole number i.e. Nett: 81.47 increase by 15% to give me the total and > vice versa 92.27 decrease by 15% (I can do this on the calculator). Formula > NOT reliant on other cells. > > Appreciate your help

0 |

2/18/2010 1:46:01 PM

"Shevvie" wrote: > I want to be able to create a forumla to increase > or decrease the percentage of a whole number i.e. > Nett: 81.47 increase by 15% to give me the total > and vice versa 92.27 decrease by 15% (I can do > this on the calculator). Formula NOT reliant on other > cells. =81.47*(1+15%) =92.27*(1-15%)

1 |

2/18/2010 2:55:01 PM

Hello, Many thanks in advance! I know very little about Excel....but here i what I thought was a simple exercise: I wanted to sell some stock. Since the stock isn't doing too well righ now, I wanted to compare what I paid for it (ESPP) in the past with ho it is doing today - then figure out if I'd be losing money (and ho much). Since the values fluctuate over time (Stock price), I though "Hmm...what a good way to learn Excel" :) Essentially, all I am trying to do is figure out my loss if I were t sell today, at $84.39. When trying to subtract an amount from today' price...

Hi, I have three Excel 97 formula questions: 1) Suppose I have a formula which yields a dollar value with a theoretically infinite amount of decimal places, but I use column formatting to limit the decimal places to two positions. For example, the formula: =1/3 yields $0.33333333333333333333333333333 but I limit it to two places with column formatting: $0.33 But I then am multiplying the above results times a fixed quantity. But I need to multiply the fixed quantity times the two-place value, not the infinite place value. For example, I might need "5 times $0.33", NOT "5 ...

I have 3 conditions score divided into 3 parts 50, 75 and 100 % If score in cell = > 27 then -3 If score in cell = >26<36 = -2 If score in cell = >18<27 = -1 My formula =IF(F48>27,"-3",IF(F48>=26<36,"-2",IF(F48<=18<27,"-1"))) If score in cell is > 27 shows false Please advise Cordially Beena K Process Analst Your conditions are a bit ambigous, shouldn't the first criteria be >=37 ? Conditions for the formula below: F48 >=37 result -3 F48 between 26 and 36 result -2 F48 between 18 and 25 result -...

I am trying to divide 2 cells (M1/L1) and L1 contains a formula that adds minutes together (I have the L1 cell formatted for minutes [m] - if that has anything to do with it). When it divides it comes up with a really wacky #. How do I get the cell to recognize the value, not the formula? Heather ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Try something like this =M1/(L1*1440) -- Regards, Peo Sjoblom "hgraning" <hgraning.wp1hb@excelforum-nosp...

Hello Is it possible to find the minimum Price for each Part and then display the Company that sells this part? A B C D E F Part Company A Company B Company C Min Price Company Part 1 $23.99 $21.98 $27.55 Part 2 $87.42 $95.34 $72.63 Part 2 $53.76 $62.51 $61.87 Thanks Ruan Hi! To find the minimum (lowest) price: =MIN(B2:D2) To find the company: =INDEX(B1:D1,1,MATCH(MIN(B2:D2),B2:D2,0)) Note: if there i...

I have the following in a spreadsheet: A B C D E F G H row 1 1.1 1 76 71 #N/A 71 5 row 2 1.2 1 124 117 #N/A 117 7 row 3 1.3 1 156 159 159 159 3 row 4 2.1 2 12 5 #N/A 5 7 row 5 2.2 2 54 59 59 59 5 row 6 3.1 3 41 45 45 45 4 row 7 3.2 3 252 310 310 310 5 row 8 3.3 3 305 438 310 310 5 row 9 3.4 3 422 438 438 3 row 10 3.5 3 441 #N/A 438 3 row 11 4.1 4 33 35 35 35 2 row 12 4.2 4 107 111 111 111 4 row 13 4.3 4 180 175 #N/A 175 5 row 14 5.1 5 227 230 230 230 3 My array formula in column H is as follows: ={SMALL(($C$1:$C$14=C1)*ABS(G1-($D$1:$D$14)),COUNTA($C$1:$C$14)- COUNTIF($C$1:$C$14,C1)+1)} ...

I would like to keep track of my credit card expenditure while away on holiday Florida. I was thinking of an Excel spreadsheet I could keep on my PDA - something along the lines of; A B C 1 AVAILABLE 2000 UKP 3600 USD 2 3 PARKING 70 ??? 4 HOTEL ??? 250 5-20 etc. etc. 21 SPENT 208 376 22 BALANCE 1792 3224 I have taken the conversion rate in the example above from...

Hi, anyone know how too make a formula inn excel that can find how many days there are left too "for exsample when people turn 50 years from their birth? Try: ="Will be "&DATEDIF(A1,TODAY(),"y")+1& "in "& IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))>TODAY(),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY(),DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1))-TODAY()) &" Days time" or with a bit more text: =IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))=TODAY(), "Birthday today!","Will be "&DATEDIF(A1,TODAY(),"y")+1&...

Without changing any of the options to reflect the formula in a worksheet, though an Excel worksheet function is it possible to return the formula in another cell. E.g. Cell A1=sum(a2:a200) The value returned and represented in the worksheet is say 2000 I want to return the text "=sum(a2:a200)" through a formula and not VBA. Any ideas or suggestions? Thanks in advance I suppose I could create a custom function for this but I want to avoid this if it can be done through Excel functions. "Geoff" <gh@bob.com> wrote in message news:OrXu7WeYFHA.4032@tk2msftng...

Hi. I want to solve a linear of n X n equations system in Excel, where the solution can be derived as follow: Xn = ao Xn-1 = a1 * Xn Xn-2 = a2 * Xn-1 + a3 * Xn Xn-3 = a4* Xn-2 + a5 * Xn-1 + a6 * Xn e.g. The an coefficients (a0,a1,a2,….an) are all known. Lets simplify the above system using an example. Lets say that n=5 and: X5=7 X4=2*X5 X3=3*X4+2*X5 X2=1*X3+3*X4+4*X5 X1=1*x2+1*x3+1*x4+2*x5 (Then the solution is: X1=210, X2=126, X3=56, X4=14 and X5=7) Any idea how can I solve these n x n equations in general form in Excel? (I tried with sumproduct() but I stuck in coeff...

I have data with two columns on Sheet A as shown below. I need a formula in column A of sheet B to display column A of sheet 1 the number of times as indicated in column B of Sheet 1. Zero values should be excluded. I gave an example of the output I need below Sheet A 100 0 101 5 102 3 103 0 =============== Sheet B (Example of output I need) 101 is 5 times and 102 is 3 times. I need a formula on this sheet, and can not use VBA. 101 101 101 101 101 102 102 102 Hi, Assume that the data is in range C18:D21. ...

"Mr L Hibbert" wrote: hello im trying to compile a small folder consisting of different worksheets, each worksheet is a different customers sales etc.... with totals for JAN, FEB etc throught to the year, these totals for each customer month are to be summarised in a summary spreadsheet, how do i extract the data from the customer folder to the summary box. at the moment i can only a = formula, but copy and paste does not allow the boxes to use the formula for all the sheets, this is hard to explain For example A - summary B - customer 1, detailed sal...

Hi to all [Apologies if this post has already been attended to. After posting the question, I could not download any headers and hence could not see if my question was indeed posted (or answered). I tried twice so it might have appeared twice! Then due to a glitch at the service providers, all postings from Saturday afternoon till Monday morning were lost including my post and possible responses. So please could somebody help me. If there were any responses, please repost or send to me (jbircher@iafrica.com)] If not seen before, here is the original query: I would really like to en...

Hello, I need help fast! I need to be able to insert a Formula into rows that contain certain text. I then need to be able to copy all this formula across 15 columns and down to the end of the active workbook for each row that contains this criteria. I want the formula to automatically update to the correct cell reference. My formula is rather lengthy but it works perfectly in a 'normal' spreadsheet without running a macro. This is what I have: Dim intx as Integer Dim lngrow as long ActiveCell.SpecialCells(xlLastCell).Select lngrow = ActiveCell.Row 'lastcell in spreadsheet ...

how do i make a formula so that a specific cells continuosly accumulates every time another amount on a different cell is entered. eg: on a payroll sheet, the year to date field What do you want to accumulate the number of entries [use the =Count(range) or =counta(range)function], or the value of the entries [use the =sum(range( function)] ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Hi zerep, Check here for info: http://www.mcgimpsey.com/excel/accumulator B...

I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute the info for my character. I am having a probllem with the casting total for spells related to a paticular character. The Formula is as follows : =IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2)) I am trying to compute the casting total for the spells castable by this character. The total for the ...

IF cell A1 contains the word "DAM" in any part of the cell then cell A must equal "UNAVAILABLE" the key here is that the cell needs to contain the word "DAM" and if i does i need it to be identified in a seperate cell. Any suggestions?? Many Thank -- Message posted from http://www.ExcelForum.com Hi try =IF(ISNUMBER(FIND("DAM",A1)),"Unavailable","") >-----Original Message----- >IF cell A1 contains the word "DAM" in any part of the cell then cell A4 >must equal "UNAVAILABLE" > > >the key he...

Hi, I am looking for a formula that would calculate one cell if anothe cell has a letter. For Example: A B 1 X 7:00 2 Y 3:25 3 Q :25 4 x :45 I want excel to count in column A and find all of the "x's" and add u how much time "column b" it took. So I want excel to come up with 7:45 (adding b1 and b4 and any other "x's" that have a time in column b) Thanks -- 867503 ----------------------------------------------------------------------- 8675039's Profile: http://www.excelforum.com/member.php...

Hi, I downloaded an excel file from an .asp web page internet site. Once in local mode, this strange thing appens: all the cells, that contains data and numbers at video, seem to be empty when I try to edit a formula (e.s. Sum, Sort ...). Office version is the same on all machines (Office 2K sr1 9.0.3821 with no service packs), installed on Win2k Pro SP4.The most strange thing is that on some desktops with WinXP Pro in the same network environment, the file seems to work perfectly. Any suggestions, please? Thanks ...

I have the following formula in cell c1 in a spreadsheet: =IF(D1>A1,IF(B1="over","+"),IF(D1<A1,IF(B1="over","-",IF(D1<A1,IF(B1="under","+"),IF(D1>A1,IF(B1="under","-")))))) 200 over - 195 200 over + 205 200 under FALSE 205 200 under + 195 What I've done above is test the formula for all four possible outcomes. As you can see the third outcome in the table (the fourth argument in the formula) is false, but I want it to read "-". I have changed the formula around every way I can thi...

I get a column of school name and want to use this column to determine the goodness of a school. i.e. =if(OR(a1="...",a1="......",.................,a1="......"),"Goo School","Bad School") However there are too many schools in that column, so when I paste th equation to a cell, an error message occur: formula too long. How can I solve it -- hurrianc ----------------------------------------------------------------------- hurriance's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3088 View this thread: http://ww...

The reference below is in an entire column of cells. The cell C7 is a number (14,000) that appears to be a constant multiplier for the entire column. I'm trying to find out what the , in front of the cell reference signifies, and what "TABLE" is being referenced. Thanks! {=TABLE(,C7)} ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** Mike Polo wrote... > The reference below is in an entire column of cells. The cell C7 is a > number (14,000) that appears to be a constant...

Hi, I have several hundred different formulas on one spreadsheet like this one. =VLOOKUP($C$1,'P:\Rate Sheets\client name\[file name.xls]manager name'!$BV$67:$CL$131,3,FALSE) The results sometimes return #DIV/0!, or other error messages which ruin my attempts at summing the results as well as the visual appeal. Is there a way to rewrite (en masse) these formulas to so that they first check "If(iserror(myformula),[then] 0, [else] myformula) so that rather then an error result I will see a zero (0).? I can manually change them but that would take a day at lea...

I have been having problems with incorrect calculation of column totals when using the SUM function. The data I have entered in the column to 20 decimal places are as follows: 7.4, 10,14.7 and -32. These should total 0.1 but excel calculates the total as 0.09999999999999430000 I am using Excel97 does anyone else have similar problems and does this also occur with later versions of Excel. Thank you. John john.bedford3 wrote: > I have been having problems with incorrect calculation of column totals when > using the SUM function. The data I have entered in the column to 20 decimal &g...

I am using an offset formula to bring back data. I am trying to bring back the cell next to the one that has a label that matches the file name e.g. the file name is Place and then column a contains a list of places and column b contains text about those places. I am using the following formula: =OFFSET(Data!A15,MATCH(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5),Data!$A$15:Data!$A$37,0),1) Where Data! refers to the sheet which contains the data and t...