Newbie - Unable to do Simple Formula(s)
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...3 Formula Questions
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:
but I limit it to two places with column formatting:
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 ...Formula help required
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
If score in cell is > 27 shows false
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 -...Adding cells that already contain formulas
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
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Try something like this
"hgraning" <hgraning.wp1hb@excelforum-nosp...Lookup formula
Is it possible to find the minimum Price for each Part and then display the
Company that sells this part?
A B C D
Part Company A Company B Company C Min Price
Part 1 $23.99 $21.98 $27.55
Part 2 $87.42 $95.34 $72.63
Part 2 $53.76 $62.51 $61.87
To find the minimum (lowest) price:
To find the company:
Note: if there i...Having difficulty understanding SMALL function in formula
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:
...Quick Excel formula question before I go on holiday tomorrow!
I would like to keep track of my credit card expenditure while away on
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
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...Formula inn excel
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?
="Will be "&DATEDIF(A1,TODAY(),"y")+1& "in "&
&" Days time"
or with a bit more text:
"Birthday today!","Will be "&DATEDIF(A1,TODAY(),"y")+1&...Formula as text #2
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
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" <firstname.lastname@example.org> wrote in message
news:OrXu7WeYFHA.4032@tk2msftng...Help for formula.
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
The an coefficients (a0,a1,a2,….an) are all known.
Lets simplify the above system using an example. Lets say that n=5 and:
(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...Help with difficult formula requirement
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 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.
Assume that the data is in range C18:D21. ...formula patterns with a gap of two
"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
A - summary
B - customer 1, detailed sal...Rank scores formula
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
So please could somebody help me. If there were any responses, please
repost or send to me (email@example.com)]
If not seen before, here is the original query:
I would really like to en...Insert Formula and Copy to other cells
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
lngrow = ActiveCell.Row 'lastcell in spreadsheet
...Formula question #2
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/
Check here for info:
B...Formula for Game Spreadsheet
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 :
I am trying to compute the casting total for the spells castable by this
character. The total for the ...If Function formula
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.
Message posted from http://www.ExcelForum.com
>IF cell A1 contains the word "DAM" in any part of the
cell then cell A4
>must equal "UNAVAILABLE"
>the key he...Count If Formula
I am looking for a formula that would calculate one cell if anothe
cell has a letter.
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)
8675039's Profile: http://www.excelforum.com/member.php...Excel file downloaded via web
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?
...Help with Formula Please
I have the following formula in cell c1 in a spreadsheet:
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...Formula too long (If)
I get a column of school name and want to use this column to determine
the goodness of a school. i.e.
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
hurriance's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3088
View this thread: http://ww...Mystery Formula
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.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
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...Sandwich existing formulas with "If iserror(formula),0,formula)"
I have several hundred different formulas on one spreadsheet like this one.
=VLOOKUP($C$1,'P:\Rate Sheets\client name\[file name.xls]manager
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...Errors in formula calculation
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.
> I have been having problems with incorrect calculation of column
> using the SUM function. The data I have entered in the column to 20
&g...Offset Formula Query
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:
Where Data! refers to the sheet which contains the data and t...