Square Root Spiral Function Graph...

Nov 10, 2006

Square Root Spiral Function Graph. i was looking for vba code to graph the Square Root Spiral from Pythagorus in Excel...?

View 8 Replies


ADVERTISEMENT

Module Function (square Root Always To Be Positive So I Get A Result)

Dec 7, 2009

I have a formula and in it is a square root, i want the formula inside the square root always to be positive so i get a result.

Example:

(A1)
-1
(A2)
0
(A3)
-2

(C1)
=(A1)^0.25
(C2)
=(A2)^0.25
(C3)
=(A3)^0.25

Now i only get a result from the last two, but i want to use the modulus function so that instead of a maths error i get 1 for the first one, how do i do this?

View 2 Replies View Related

Finding Whether A Number Is A Square, Or Whether Square Root Is Integer

Aug 19, 2009

I need a formula to tell me whether a number is a square number, or I can do it so to see if the square root of a number is an interger. So far Iv been doing

A1 = 2
A2 = AND(RIGHT(A1,1)=INT(A1))

True or false outcome is fine, and it has been working fine on some examples, but the problem comes when I have 49, as it is 2 digits long. I've seen a formula similar to find the root symbol, and look at all the numbers upto this point (maybe FIND).

View 3 Replies View Related

Square Root With Userform Textbox's

Oct 2, 2006

i am trying to use the square root formula to work out the top length of the picture on the userform from the numbers i have in the textbox's.

It is basically a 10x5 rectangle and i need to find the diagonal length

which should be 11.18 but it is returning 10

View 5 Replies View Related

Graph Rational Function

Jun 20, 2007

when graphing a rational function (y = 1/x) i get a line crossing the asymptote (y axis for this function...)

View 5 Replies View Related

Graph Trigonometric Function Results

Sep 20, 2007

graphing trigonometric functions...

sin and cos seem to work easily, but i'm having trouble getting the tangent function to graph (look) correctly...?

View 5 Replies View Related

Solver Root

Nov 17, 2008

I created a trendline and associated equation for some data plotted against Time on the x-axis displayed in MM/DD/YY format. The date for the data ranges from 3/27/06 thru 11/10/08.

The trendline equation is

F(x)=-6E-13x^5+1E-07x^4-.0087*x^3+329.1*x^2-6E+06*x+5E+10

The data actually crosses the y=0 line around 11/5/07, which is the data root

When I use Goal Seek, I got a zero root solution of 28154.98. When I convert this to the date format, it converts to a date in 1981 which is not correct. I tried a range of initial guesses but they all converge to the same number.

View 9 Replies View Related

Root Sum Calculation

Nov 5, 2009

How set up root sum calculations.

A1 has 0
B1 has 0
C1 has 9

on D1 would like to show the root sum of 009 (which is 9). What is the best formula for cell D1?

A1:C1 will have random input numbers between 0-9.

View 9 Replies View Related

SMALL Function For Update Graph Dynamically

Apr 21, 2009

I have a Big Question about the SMALL Function in Excel. I would like to know if it is possible to use a syntax that will make the small function update my graph dynamically.

Personnel transfer out of the Department on know dates... but they come in to the Department all the time. I would like to know if I can increase the "range of my data" even if I don't have data in the cells (i.e. B2:B6 have data, I want the range to include B7:B16, which has no data)... When I have no data in the cells I get errors/ circular references...

Ideally, I would like be able to add or remove personnel and the SMALL function would "organize/update" my graph dynamically. Is this possible?

View 6 Replies View Related

Cut Root Domain From URL String

Feb 23, 2014

I have a long url and I need only the root domain in the url.

for example:

[URL] .....
[URL] .....
[URL] .....
[URL] .....
[URL] .....

View 2 Replies View Related

Excel Sine Wave Graph/function Making

Feb 15, 2010

i have some numbers as data, i want to find the function that generate thiese numbers and also i want to view the chart of it, its kind of sine wave graph.

View 9 Replies View Related

Nested IF Statement To Recognize Root 'codes'

Jul 6, 2009

if the code is 110 add together all amounts attached to that code and sum them in a new cell. Perfect. Now however there is an added level of complexity and i need to figure out how to nest an IF statement into a =sumif() function so that code amounts are summed into their root code, for example the root code of 110, 120, 130 is 100.

So basically i want a function that will sum the specific code (110) and then sum together that amount under the root code (100). Here is an example. The amounts for the lower level codes have been summed but i need the high level codes to be summed together.

View 4 Replies View Related

Open File By Searching Root And Sub Folders

Jun 5, 2009

is it possible to type a document name in a cell,then run a code that searches a root dir and sub folders, find the existing document and open it?? for example

cell: "D20"
filename: DYAZES-001
root dir: "I:IsolationDataBaseIsolationProcedures
subfolders: DryMillA, DryMillB, Despatch, Maintenance

View 5 Replies View Related

Defining System Root On Different Versions Of Windows

Feb 22, 2007

I have to run a daily report from winxp or win2k and need to change the host files a few times for access.

I tried to use %systemroot% in the file path, but for some reason vba doesn't like it.

Here's the snippet I'm using for copying over the host file based on user choice: (the thing works if I change to the actual system root path (C: etc...)

Private Sub CommandButton1_Click()
Select Case ComboBox1
Case "- Choose -"
MsgBox ("This is not a choice")
Case "BTR"

View 9 Replies View Related

Excel 2010 :: Camera Function - Take Picture Of Graph And Pasting To Alternative Sheet?

May 21, 2014

Excel 2010 and the camera function.

I have been using it to take a picture of a graph, pasting to an alternative sheet within the same workbook, and renaming the picture by a defined name. S by selecting the names from a drop down list the picture will select various different sized graphs defined within my drop down.

What I am experiencing is when I initially do this the pic works great and resizes automatically with each selection, however the next day some of the pictures resize and some do not.

Is this a glitch within excel or am I missing a setting which will resolve this?

View 1 Replies View Related

Excel 2003 :: Browse For Text File When Folder Root Is Known But Filename Unknown

Apr 25, 2012

I have run into a problem in a project where I know what the folder root of the file I would like to import into excel is, but I do not know the file name.

I would like to open a dialogue open where I can select the file I wish to import from the known root supplied and retain the file name as a string.

All solution I have read assume the full file root is know or file name is known but root is unknown

I am working with Excel 2003.

View 2 Replies View Related

Punnet Square

Aug 15, 2006

I am doing a cross between two parents, whose possible genotypes are AA, BB, or AB.
I want to use if clauses to look at the parent genotypes, (paternal is listed in column E and maternal is listed in column F) and then give me the possible recombinant genotypes in column G. there are 9 possible combinations (recombinants in parenthesis)

AA x AA (AA)
BB x BB (BB)
AA x AB (AA, AB)
AB x AA (AA, AB)
BB x AB (BB, AB)
AB x BB (BB, AB)
AB x AB (AA, AB, BB)
AA x BB (AB)
BB x AA (AB)

I tried using if clauses, but i don't think i can nest more than 7 cases, and I have 9 different combos.

View 4 Replies View Related

Index - All Up All Square Feet

Mar 13, 2014

I have 6 rows A1-A6(sheetsize), they can be 1 of 8 numbers. (16,14,12,10, 5/8, 1/2, 3/8, 3/16) these are all metal gauges. The cell next to them B1-B6(sheetgauge) has a number that refers to how much sq ft each of these sheet metal sizes has. I would like a cell below A30 to add up all the sq ft in B1-B6 if it is 16 gauge. Then A31 will add up all the 14 gauge, etc.

How is this possible without having a huge formula.

Here is my standard formula, but it wont add the B cells together if more than one of the same sheet sizes.

=index(sheetsize,match(A31,sheetgauge,0))

View 2 Replies View Related

Use Of Square Brackets In Vba 2003

Jan 8, 2010

My code works great on my computer but when I bring it to another computer it gives me errors. I think it has to do with my use of square brackets to reference cells. the error that comes up is

compile error:
can't find project or library

What I'm doin here is going to my template sheet then getting the info from different cells and then later using it somewhere else. in place of using range and selecting cell I am using square brackets to select a cell. it worked fine on my computer and was a lot less writing, here is a small part of my code

View 9 Replies View Related

Square Brackets - Vba Notation

Mar 22, 2007

I often see square brackets around ranges in code. eg [A1]

if there are any advantages/disadvantages with using this notation, apart from the obvious its shorter?

View 9 Replies View Related

Passing Cell References From A Cell's Text To LINEST Function And A Graph

Mar 2, 2009

I'm using Excel 2003 and I'm trying to make my LINEST function and the source cells for a scatter graph use the cell range specified in another cell in the document. I figured out that it was simple to do the following:

I250 contains: 10, shows: 10
I251 contains: ="I"&I250, shows I10

But I can't figure out how to do this in a larger function. I've tried a few things but none of them work. Here is an example where I want it to do a LINEST with y values in cells Ja - Jb and x values in cells Ia - Ib (where a and b are integers specified in cells I250 and J250 respectively):

View 9 Replies View Related

Address Separated By TWO Square Characters

Feb 15, 2009

An address is separated by the square characters, and usually I would use Text to columns>Delimited>Other>Alt+0010 to separate the lines. When I get to the Delimited screen where you check Other and enter Alt+0010, the keyboard just makes beeping noises and the text preview only shows the part of the address prior to the soft return, as if there is no char(10) delimitation.

Sheet1 I11299 S Taylor St. #12
Shakopee, MN 553792880 Tuva Rd.
Cokato, MN 5532131381 360th Ave
Siren, WI 5487245824 Dupoun Ave. N
Brooklyn Center, MN 554305718 Garden Lane #2
Shakopee, MN 553796583 Hall Ave
St. Paul, MN 5510771615 South 4th St. #2003
Minneapolis, MN 5545481525 6th Ave S #8
St. Cloud, MN 563019715 S Glen DR
Bloomington, MN 5542010340 2nd Ave. S. #344
Waite Park, MN 56387 Excel tables to the web >> Excel Jeanie HTML 4

View 9 Replies View Related

Make A Scatter Graph That Will Graph The Attached?

Mar 21, 2014

I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.

View 7 Replies View Related

Formula To Convert Inches To Square Foot

Dec 30, 2008

I need a formula to automatically convert inches to square feet. I have =IF(G5>12,G5/144). and G5 is the cell used to enter your inch value. The formula wrks great, but only if you enter over 12 inches. I'm pretty sure Im on the right track, just need to know how to add in the part about if its less than 12 inches it should be multiplied by 12.

View 5 Replies View Related

Extract Numbers For Square Footage Calculation

Jul 14, 2009

I'm a new member to the forum and have a question about extracting numbers from a string for a square footage calculation. I am trying to extract the two numbers of varying length on either side of an "x" within an alphanumeric string. As you can see from below, the only constant is that each string will contain an "x" (assume there will be no other "x"'s in the string). I am trying to achieve the following:

A1 = 36.5 x 112 --> B1 = 36.5, C1 = 112
A2 = 36.5x112 --> B2 = 36.5, C2 = 112
A3 = 36.5' x112 --> B3 = 36.5, C3 = 112
A4= 36.5'x112.5' --> B4 = 36.5, C4 = 112.5
A5= abc123 36 x 112.5' --> B5 = 36, C5 = 112.5

If there is a non-VBA code fix, that would be preferable (mix of MID,FIND,MATCH functions...?), but I am okay with some basic VBA.

View 4 Replies View Related

VBA Square Option Buttons With Check Marks?

Feb 4, 2014

I try to make option buttons instead of round with a black dot but square box with check mark liked the check box. Box can be filled with color (light blue or other color). When the box is picked the fill change to white background.

I have 5 option boxs, I like to group them in one group because I have other groups using the option boxs. I want the check mak stayed in that group when it is picked.

View 14 Replies View Related

Formula For Calculating Largest Square To Fit In A Quadrilateral

Feb 23, 2010

I know this ain't going to be easy if at all do-able, but would anyone know if there can be a formula/s made to calculate the largest size "square" shape (e.g. all 4 corners at 90 deg.) that would fit in to a known size Quadrilateral?

Value A,B,C,D and Z are all known values as are the diagonal lengths between corners

I failed dismally in Geometry at High school, but how was I to know that 35 yrs later I would need to know this stuff!!

Please see diagram for an idea of what I'm trying to achieve.

View 10 Replies View Related

Macro For Removing Contents Within Square Brackets

Feb 22, 2012

(Split cell into multiple rows) I need a macro to remove contents within brackets in a cell.

Example:
A1 contains
[something, separated; a, couple of times; like, this] With, some; other, text

The result should be:
With, some; other, text

I want the macro to remove the brackets and everything within it for all marked cells. (I do not want to use search and replace function since I got a lot of these data and needs to repeat this procedure).

View 9 Replies View Related

How To Remove Square Carriage Returns From My Cells

Oct 12, 2007

I have a worksheet containing square carriage return symbols (see below).

EXAMPLES
Eg1. Baked[]Beans on []Toast
Eg2. Smoked[][]Salmon in Brine
Eg3. Ice[][][] Cream [][]Cosmopolitan
Eg4. Mixed[]Nuts[][]per kilo[][][][]
Eg5. [][]Baby Shampoo[]Fragrance Free

This data was extracted from an SQL Database and dumped into Excel.

I would like to know if someone can suggest a script to replace all occurrences of [] with a space.

Once I perform this, I can then perform a Search/Replace function as follows:

Replace 4 spaces with 1 Space
Replace 3 spaces with 1 Space
Replace 2 spaces with 1 Space

Hopefully then, the final result will appear as follows:

Eg1. Baked Beans on Toast
Eg2. Smoked Salmon in Brine
Eg3. Ice Cream Cosmopolitan
Eg4. Mixed Nuts per kilo
Eg5. Baby Shampoo Fragrance Free

Eg5. is a little tricky because a space will appear at the beginning of the cell (see above). It would be good if there's a script to remove occurrences of this also.

View 9 Replies View Related

Selecting Diagonally, Square-shaped Selection

Jun 5, 2008

I am trying to select the cells in a column and then all of the adjacent cells to the right.

If I record a macro, it looks like this:

Range(Selection, Selection.End(xlUp)).Select
Range("C5:D9").Select

How can I turn those static cells into volatile cells (I think that's what you call it)?

I basically want to select from the active cell (C9) to the beginning of the column (but leave out of the selection the header row) and then the adjacent cells to the right (D5:D9), but not with fixed cell references.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved