Auto change formula in cells when source is changed
Good day experts;
If specific cells have the same formula for example:
C1 = Product( A1;B1)
C16 = Product(A16;B16)
And so on ...
What formula should i write in C16, C17, ... so that:
when the formula in the source cell, C1, is changed the formulas in C16,
C17, ... would automatically change accordingly.
I tried "=C1" it does not work
Thanks in advance
> Good day experts;
> If specific cells have the same formula for example:
> C1 = Product( A1;B1)
> C16 = Product(A16;B16)
> C17= Product(A17;B17)
> And so on ...
...Sumif returning incorrect value
Operating System: Mac OS X 10.5 (Leopard)
I have data in columns c to f and rows 2 to 20 <br>
I also have data in a2 to a20. <br>
I am trying to sum the data in s2 to f20 when the row matches my criteria in a2 to a 20. The formula that I am using is <br><br>sumif(a2:a20,"=12",c2:f20) <br><br>the result will only sum the values in column c. <br><br>Does anyone know what the problem is? <br><br>Thanks <br><br>Allan
SUMIF() has various limitations.
this will work,...How to make autostart programs in USB stick memory
Some said, when USB memory stick putting on PC, it can start autostart
programs, like Autorun.inf of CD-R. Does any know how to do it?
> Some said, when USB memory stick putting on PC, it can start
> autostart programs, like Autorun.inf of CD-R. Does any know
> how to do it?
Most systems these days have autorun disabled. ;-)
(for good reason.)
How To Ask Questions The Smart Way
> Some ...How to bold daily max values
I have one year of hourly data in one column and the date in another column.
I'd like to write some excel functions to bold the daily max values. Any help
is greatly appreciated!
Conditional formatting would do this, but I don't understand the data. Can
you post some sample data?
"Ginger" <Ginger@discussions.microsoft.com> wrote in message
> I have one year of hourly data in one column and the date in another
> I'd like to write some excel functions to bold t...why do i get #### in my formula cell?
I don't really know much about Excel, and my formula (it's just simple
arithmetic formulas) returns with ##### displayed on the cell, with a tooltip
showing the cell's correct value when I hover over it.
airn, make the column wider and see if that helps
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 2002 & 2003
"airn" <email@example.com> wrote in message
news:C6F4DD7C-3D7D-475C-894D-0F7745735666@microso...how i can make the numbers
hi i am fatih
fistly sorry my english is not good
my trouble is haw can i will write the number of the
for example 1.000.000.000
=yaziyla(b42) (one milyar)
and tahan my office version is turkish version
thank you so your company will interesting my problem
If I understand you correctly, you want a formula to translate numbers to
words (in Turkish).
Laurent Longre has a language version of an function which offers this
capability. It is at http://longre.free.fr/english/
I don't know if it supports Turkish, but if not, send me the Turkish words
for all...Formula #16
I need to have a formula that can add a row of cells with a variable
number of colmns. Columns will be added and deleted everyday, so the
formula needs to have a variable range.
I hope this is clear.
...Excel formula copied down
Is there a way to copy down a column this formula =F3*A2 and have the A2 stay
the same all the way down? The F3 would change on each row, F4, F5 etc. but
the A2 would stay 'constant'.
Thanks in advance for any help!
"Pat" <Pat@discussions.microsoft.com> wrote in message
> Is there a way to copy down a column this formula =F3*A2 and have the A2
> the same all the way down? The F3 would change on each row, F4, F5 etc.
> the A2 would stay 'constant'...polynomial formula for a line graph...
I haven't looked at this feature in a couple of years.
Excel can give you the formula for a charted function...
what I mean is, given a few data points, it can create a
best fit curve, and display the function that it used to
Would someone remind me where, please?
Right click the data series and pick Add Trendline.
From the dialog you can choose the type of trend line and whether to
display the formula.
> I haven't looked at this feature in a couple of years.
> Excel can give you the formula for ...simple? pasting simple formula, error on copy
I have some store buying spreadsheets I made up.
Very very basic, one of the columns has a total at the bottom or end as you
may call it for total $ amount bought. that final number is in c33. c1, c2,
c3 etc is a amount from each vendor.
I want to have a column telling me the percentage being spent on each,
simple enough so I make a column with the following formula =c33/c5. I get
a number, change it to percentage and BAM I have exactly what I want. I
pasted that formula and pasted it into all the other rows of that certain
column, but I keep getting the #div/0 error, cause the new formulas...Can you make a crossword puzzle by putting the words in?
I have to make a crossword puzzle for one of my classes, and was wondering if
there is a program on my computer that will show me how to make the crossword
puzzles. If you can help that would be great.
Perhaps this MS link would be of interest:
"Design a Crossword Puzzle in Microsoft Excel"
GMT+8, 1° 22' N 103° 45' E
> I have to make a crossword puzzle for one of my classes, and was wondering if
> there is ...Help with creating a formula
I am trying to create a formula that will sum up certain criteria from one
column as it relates to criteria in the same row in another column. For
example, I want to sum up all the entries that begin with the letter "H" in
column A as it relates to an entry of "2" from column B that is in the same
row as the "H" entry from column A.
COLUMN A COLUMN B
If there is such a formula...Excel does not calculate my formulas
This is very strange...Excel does not calculate any formula. I can do a
simple =A1+A2, and it just return a zero value.
I made sure of the following:
- Cell is set to General (tried it with different cell settings too)
- Autocalc is on in settings (even a manual F9 calc doesn't work)
We might need a few more clues:
What is in A1? What is in A2?
"Martin" <Martin@discussions.microsoft.com> wrote in message
> This is very strange...Excel does not calculat...excel chart showing movable graph at what point we make a profit
in a business would like to make a chart based on accumulated Earnings &
Profit/Loss for year to date, perhaps movable showing our break even point
and by moving chart to a another earnings figure what profit we should make.
For example put in earnings for YTD Profit/Loss YTD then I can move the
earnings part of the chart to show what our profit would be for a given
If For example if we earn $200 for year so far and profit is $0 but any
amount over that is 18% profit so I can move chart line to say $240 and it
will say what profit I will make.
Hope ...need to allow negative quantitys on purchase orders
because our vendors list returns and exchanges on invoice i need the abillity
to enter negative quantitys when recieving manually.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us...Statment of changes in financial position
i will be a demo of GP 10 on Weds for a customer who has a requirement for a
statement of changes in financial position. Is there any reason that this
would be a problem in FRx as long as i know what GL accounts make up each row?
Their sales and receivables are going to be maintained in another systmer -
with that system providing a journal entry either weekly or monthly.
How did this come out for you, also have you done a Schedule of Changes
Report?? Pretty standard non-profit reports.
"Andrea Smiley" wrote:
> i will be a demo of GP 10 on Weds for a cus...how do you make pictures your slide background
iam am trying to make a map of the hundred years war my actual background not
tryng to make a picture slideshow in ppt. 2003, in the same way you can
change the back ground fill or make a whole new slide design also how do you
make i template in ppt. i kinda forgot
This should get you started:
Design efficiently with masters:
MOS Master Instructor
"ppthelp" <firstname.lastname@example.org> wrote in message
...Outlook keeps making itself Default
Everytime I start Outlook it takes over as default for email and addresses
even though I have that option unchecked in outlook, and in IE I set OE
Express as default, yet each time I launch outlook it takes over as Default,
...can I make cell "yes" equal 1, "no" equal 0
in another cell?
(remove nothere from the email address if mailing direct)
"can I make cell yes equal 1, no equa" <can I make cell "yes" equal 1, "no"
email@example.com> wrote in message
Picky but I don't think that you need the " +(A1="no")*0 " Just
=IF(AND(A1<>"yes",A1<>"no"),"&quo...HOWTO Make CDialog's with ActiveX in a LIB.
HOWTO Make CDialog's with ActiveX in a LIB.
I'm having a heck of a time trying to get a CDialog derrived class host a
single ActiveX control (the CWebBrowser control), from a static LIB. When the
OnInitDialog for the class call's CDialog::OnInitDialog it bombs inside the
DoDataExchange for the DDX_Control of the control. Specifically at
dlgdata.cpp line 43, with the following ASSERT:
TRACE(traceAppMsg, 0, "Error: no data exchange control with ID 0x%04X.\n",
The reason why this ASSERT fails is because the CDialog's "m_pCtrlCont" i...How do I make this formula?
I have an Excel worksheet to track my 401k performance. I have a row for
Date, the Balance corresponding to each date, Contributions, a formula to
calculate my Total Contributions, and a formula to calculate my Total
Gain/Loss. My question is, how to I get my Gain/Loss formula to update
corresponding to a new Date/Balance? Is there a formula function to make the
formula ignore Column data in the previous Rows? Thanks!
There will be, just add/subtract items from that row.
Can you show us an example with data.
(remove nothere from the email address if mailing direct)
&...Find a value in cells
I have something like this :
I'm doing a max function in the number column and it returns me '5'
But, after that, I want to know the letter which corresponds to the max
How can I do that?
nicgendron's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25151
View this thread: http://www.excelforum.com/showthread.php?threadid=386417
Let's say that...POS is making me angry!!!
This program has not seemes to work correctly since the day I bought it.
The problem I am having recently is NOTHING will apply.
I want to make a buy X get Y discount to apply automatically during a
transaction. I set up the discount apply all the items I want to it, and
edit it in the item properties, but it won't apply during the transaction.
I need 2 receipts to print automatically on a sales transaction. I change
that in the receipt format in Manager, but POS still won't print 2 receipts.
It's very irritating, I've restarted all the programs and even r...Logical Filtering based on Value
I've been using this formula to sort some values and return results
--I used ALT-ENTER between each formula so as to see thing clearly
Column A values can be "B01"
Column B values can be "BRN"
Columns I & J are values, one being lowest the other being highest
On another sheet I...Copying values from place to place
Is it possible say, to type a value in a textbox in one form (Form A),
automatically copy that value, then open another form( Form B) and
automatically paste that value into another textbox in Form B? Is this
Thank you for your help.
If you open Form B from Form A you can use the OpenArgs of the OpenForm
command line to pass a value to Form B.
On the OnLoad event of the Form B you can use set the value in the text box
If not IsNull(Me.OpenArgs) Then
Me.TextBox = Me.OpenArgs