coping formula #2
I am trying to copy a formula down a column. When I copy the formula down I
want the cell to be blank until i fill out the cells to give me my balance.
My three columns are
Debit / credit / balance. My formual reads : f7(balance column)+e8(credit
column)-d8 (debit column)
when i copy the formula down form my balance column it gives me the balance
in every cell. I would like for it to be blank until i fill in my debits and
credits. I hope you understand the way i wrote this
Message posted via OfficeKB.com
=IF(...printing sheet formulas
I need to print an Excel application which consists of many files that contain formulas, macros and add-ins. First, I want to print all formulas contained in a file (not the contents of the cells but the formulas) so that I can have a "blueprint" of the application as it is referencing multiple sheets and column names etc. I want to do this one file at a time. Then I want to examine the contents of the add-in that was created by the company many years ago aka not a Microsoft addin. Where can I go to see the contents and what the addin is doing? Everywhere I have been shows noth...Nested Formula Giving Incorrect Answer
I am looking at an issue one of our staff has. He is using the below formula
across a set of data
This returns 0, if E13 is not disvisible by C14, or the closest integer
(rounded down) if it is. The formula works perfectly for most of the data,
but when E13 is 50,000 it throws a wobbler and returns 0, it doesn't matter
what the value of C14 is. After doing a bit of testing, and typing figures
into the formula manually, I have figured out that if a number between 50,000
and 50,002 is entered, the formula returns 0, above or...Formula to sum in columns that change weekly
I enter a column of data weekly into a spread sheet and then total each row
for the last 4,8& 12 weeks. As the column numbers to be added change weekly
I have to change the formula weekly. Is there a way to do this
Assuming no blanks, this will total the last 4, 8 and 12 weeks in
In article <lf%Lb.3326$Zemail@example.com>,
"Robert L. Salisbury" <firstname.lastname@example.org> wrote:
> I e...Replace a portion of a formula
Does anyone know of a way that I can replace a portion of a formula
throughout a worksheet without changing the other part?
I have been able to find the cells that need to be changed by searching for
I need to change the C to a D is all cells. Is this possible?
I'd appreciate any help! Thanks!
and replace with
use the look in formula option.
MS Excel MVP
"krkward" <email@example.com> wrote in message
> Does anyon...Help with Formula logic
I have this formula in Sheet2
=IF(OR(ISTEXT(L2),ISBLANK(L2)),"",IF(OR($M2>'Sheet1'!$A2+1,ISBLANK($M2)),NETWORKDAYS('Sheet1!$A$2,$L2),"")) to store the data in the W column.
And then I use disaply it in the sheet1 by using "=AVERAGE('Sheet2'!W3:W141)"
I intend to combine two formula together so I do not need to create many
columns in Sheet2 because the A colcumn in the Sheet1 increases.
I tried to use SumIf and Sumproduct, however, I have a hard time to make it
Any suggestion will be highly appreciated.
I haven't attempted to c...List separators ; becoming \ (only in formulas in names) when opening file on another PC
I've got a worksheet for analysing data's to be shown in XY scatters graphs.
I used Tushar Mehta's excellent add-in to keep the scale limits updated all
The problem is: it works perfectly on my PC and does not work on other PC in
The names used to define the values giving the scale(s) contain formulas in
which the list separators ";" have been replaced by a (funny?) "\" (yes,
I've checked the regional settings, list separators,... They are the same on
the two other PCs I checked.
Can anybody help ???
Thks in advance
...macro to copy Vlookup formula to some cells with a filter on
I was wondering if somebody could help me with this macro…
I have some data with a filter on, so that only the rows with blank cells
I want to enter a VLOOKUP in the cell, and copy it down to all the blank
cells. I tried just recording a macro, but when I run the macro it doesn’t
Any ideas of how to do it?
Before the filter:
Colums A -B - C
A x x - 1st Row
A - 2nd Row
A x x - 3rd Row
A - 4th row
A x x - 5th row
After the fil...Excel formula translator
Very nice formula translator for MS-Excel.
Translates into 16 languages (including Google Spreadsheet)
NL, EN, DE, DK, NO, HU, CZ, ES, IT, FR, NO, FI, BR, PT, PL, SE
...Conditional format: if formula result is #N/A then make text color white? How?
I have a series of cells that I need to graph.
In order to avoid false zero values, I've used an if formula, similar to:
now I'm going to be using this workbook with some non-computer people who
are easily confused by stuff they don't understand, such as a bunch of
cells with #N/A in them, so I want to use conditional formatting to set the
text color in those cells to white (same as background) when the value
shown in #N/A.
Unfortunately, I can't figure out what I should put in the conditional
formatting box to get this to work- cell value = ??
I'...Formula help #3
Sheet1 has a name in A1 & a number in B1, name in A2 number in B2 and s
on (numbers will continually be changed). On sheet2 I used =a or =
and so on (the results of =a or =b are the names from sheet 1). Wha
I want to accomplish is every time I type =a or =b and the name appear
I also want the result from sheet1 B1 and so on to appear in the cel
directly below. Not very experienced just learning. Looking fo
Message posted from http://www.ExcelForum.com
You post is a bit vague, but if you mean you want B1 on
sheet 2 to match up with the name on Sheet 1.
=IF(...Excel formula for this...
Ok i want an excel formula to do this hopefully simple task...
Say i have cell A1 with the word "dog" in it and cell B2 with the word "Cat"
in it i want cell H5 to have the data in the previously mentioned cells so
that it reads "dog, Cat"
So in english i guess i want multiple cell values in once cell separated by
a space or a comma or whatever.
"Max Sand" <Max@gk.com> wrote in message
> Ok i want an excel formula to do this hope...Lookup Formula Question
I'm pretty new to excel and I'm wondering if anyone can help me.
I want to create a formula so that if A1=1, then F2:F5 are entered into C2:C5, or if A1=2, then G2:G5 are entered into C2:C5, etc. for more values forA1.
A B C D E F G
2 5 6
3 10 7
4 15 8
5 ...Excel formula help needed!
I would like to create a formula that would calculate a different levy
charge dependent on the amount.
The example is below and any help would be really appreciated.
In circumstances where amounts owed do not exceed £100 or $100 12.5% charge
will apply, 4% on the next £400 or $400, 2.5% on the next £1500 or $1500, 1%
on the next £8000 or $8000 and 0.25% on any additional sum.
In short different %'s will apply at different levels depending on monies
I'm sure that there will be use of If/And but I'm not sure on the st...How do I get the formula bar in excel 2003
I have Excel 2003 on two PC's - on one I have the row between the toolbars
and the worksheet which shows the formula currently being worked on "the
formula bar" as it is called if I left click on it.
On the other PC this row is not there so I have to edit all formulae and
entries in the cell in the work sheet.
How do I get the "formula bar" please >
<Alt> <V> <F>
<View> and then click on "FormulaBar".
Please keep all corre...What is appropriate formula?
a very inexperienced Excel user needs any help I can get.
I have supplier item data for yr 1 and yr 2. Year 2 has some price
ammendments and some additional items.
What formula can I use to identify any changes in year2 data?
Many thanks in advance
You need to provide sufficient details if you want some help. How is
your data laid out? Do you have separate sheets for year1 and year2?
What columns do you use, and what data do you have in them? How many
rows of data do you have? What do you want to end up with ultimately?
On Nov 13, 3:59 pm, KevB <K...@discus...Format in if formula
I want to use the "if" function and change the format
(color) of the cell if the outcome is true or false.
...Formula Question #8
I have a list of numbers seperated by spaces [A]: Next to SOME of those
numbers are other numbers [B}. The second set of numbers on the right
represent hours. All data between two spaces represents a different day. In a
third column [C], at the bottom, I want to total the hours that are in the
second column, so I know how many hours were worked for each day. (As in
parenthesis in the example below.) Is there a way to do this without using a
I hope this was clear.
A B C
H...Using formula to create multiple versions of a Graphs
I would like to be able to use a formula in an Excel 2003 graph, to
dynamically modify the source and lable data of a graph based on a cell
When I enter the number 1 into cell "a1" I would like to have the graph
automatically change to show the map points related to report 1, when I enter
2 inot "A1", I would like the source data to change to show points related to
How can this be done?
On Thu, 26 Jul 2007, in microsoft.public.excel.charting,
BarryL <BarryL@discussions.microsoft.com> said:
>I would like to be able to use a...Cube formulas and Excel compatibility
I have an Excel xlsx file that has many cube formulas (connected to local
cube built in Excel 2003). I had had to send the file to someone but before
that I had to convert all cube formulas to static values and save the file
as XLS (2003).
In order to convert the values I used the following macro:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim mwksSheetItem As Excel.Worksheet
Dim mrngCell As Excel.Range
Dim msCellValue As String, msSheetName As String
On Error GoTo ErrHandler
For Each mwksSheet...average formula help #2
We have a range of cells A1:A10 which contain values as follows:-
1 2 4 5 0 0 6 8 9 10
We need Cell A11 to display an average of A1 to A10 but ignoring the 0
values. Is this possible with a formula?
Thanks in advance
Kevin, try this =AVERAGE(IF(A1:A10 <>0,A1:A10 ))
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"kevin carter&quo...Modify a formula
This is showing how much of a novice I am, but I'm learning. I need to
change this formula so that it not only shows the message if multiples
of 84 is not entered but if multiples of 61 is not entered into the
same cell. Thanks.
=IF(MOD(F21,84)<>0,"Qty in this Row is not in multiples of 84","")
=IF(MOD(F21,84)=0,"",IF(MOD(F21,61)=0,"","Qty in this Row is not in
multiples of 84 or 61"))
"Eintsein_mc2" <firstname.lastname@example.org> wrote in message
news:email@example.com...Simplifying a formula that prevents negative numbers
Is there a shorter way of writing the following formula for calculating an
The formla calculates the alimony deductible (if any) on the 1040 return for
a given amount of total payments for alimony and child support per year.
The rules are:
1) Payments are first allocated to child support (which is not deductible)
2) Any remaining payment is allocated to alimony, subject to a maximum
amount that is required in a decree of separation or divorce; that is, any
overpayments of alimony are also not ...Full page formulas
How do I do this for every row?
=SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)
The first question is what are you intending the SUM function to do in each
of your formulae?
In what way do you want =SUM(C4*0.5) to differ from =C4*0.5 ?
In what way do you want =SUM(E4*15) to differ from =E4*15 ?
In what way do you want =SUM(G4+F4+D4) to differ from =G4+F4+D4 ?
In what way do you want =SUM(I4-H4) to differ from =I4-H4 ?
If you don't understand what the SUM function does, try looking it up in
If you want to fill the formulae down a column, look at th...countif formula #3
Would like to count the cells in a column that are filled with a color (
yellow in this case). The cells have other values for other formulas but want
to count the color filled cells.
(remove nothere from the email address if mailing direct)
"B.White" <B.White @discussions.microsoft.com> wrote in message
> Would like to count the cells in a column that are filled with a color (
> yellow in this case). The cells have other values for other...