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


ADVERTISEMENT

Countif Statement With NA Results For Chart / Bar Graph?

Mar 14, 2014

I have a countif statement based on certain criteria in a table which is reading off of a drop down list on a separate sheet.

Apple (a1) =COUNTIF(Table2[Fruits],+'Drop Downs'!A1) ...and the results are 3
Pear (a2) = =COUNTIF(Table2[Fruits],+'Drop Downs'!A2) ..and the results 0
Banana (a3) = =COUNTIF(Table2[Fruits],+'Drop Downs'!A3) ...and the results are 1

I have also set up a bar graph (this may change to a pie chart at some point) which is feeding from this. My question is, if I do not want to any results with 0 value to show up on my chart (both on the X&Y axis), how do i amend the formula to do this? I read in a couple of places about the NA() function or about just hiding the rows, but if this chart is updated "live"on a weekly or monthly basis, I would like to chart to move with the data simultaneously...so the numbers will change, sometimes they will be 0, others they may not.

View 7 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

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

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 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

Mid Function Returns Odd Results

Jun 1, 2006

I'm using the following phrase out of a much longer expression to
demonstrate that the return value of the MID function seems to be nothing I
can understand.

This expression:

=MID("6/10x",1,FIND("x","6/10x)-1))

returns 6/10 as text which makes sense. However I was under the impression
that when text in Excel contains numeric characters, it can be interpreted
as a number. So then how does the following expression,

=MID("6/10x",1,FIND("x","6/10x)-1)*1

return the result 38878? Does it still think it's text?

View 12 Replies View Related

If Function To Return One Of 3 Results

Nov 22, 2007

I am looking for a formula that will yield the following: IFAH9>AI9 return the word Green, IFAH9=AI9 return the word Blue, IFAH9<AI9 return the word Yellow. If AI9 is blank stay blank.

View 3 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

IF Function And Displaying Results As Words?

Jan 18, 2014

I am having trouble with some formulas displaying the results of the logical test as words.. For example.

=IF(E4>F4,100, IF(F4>E4, 200))

That works perfectly but I want "100" to be "Valid" and "200" to be "Invalid"

However...

=IF(E4>F4,Valid, IF(F4>E4, Invalid))

only results in the #NAME? error for me?

View 3 Replies View Related

Sum Function To Reflect Results Across Sheets

Aug 4, 2014

I am trying to sum the details from sheet2 in sheet3. I am currently using a plain formula to sum-up the values. However, create a indirect and vlookup function to sum the values.

In sheet3, I have to sum the values from sheet2 based on the contacts. Sheet1, sheet2 and Sheet3 are connected and any update(insert,delete.. etc) will be made in sheet 1 only. Sheet2 automatically updates based on sheet1. Similarly, Sheet3 should also update based on sheet1 and sum the values based on contacts from sheet2.

I have added the formula which I am currently using in the sheet.

View 14 Replies View Related

Subscripting Results Of SPLIT Function

Jul 15, 2014

I have a macro that loops through a column of cells to retrieve a price that is buried in a string. The cells in this column are formatted one of two ways. Either they are completely empty, or the following pattern of string is entered: "$181.27 ea. for 12 on 5/21/14" (the quotes are not part of the string entered). What I need my macro to do is pull out "$181.27" and then drop the dollar sign and then do some more math before inputting a result in a different cell, but the prices range from less than a dollar to over $100,000 so I need to use split instead of left. Should be simple, yes? Here is what I have:

[Code] ......

But I get an error 9: subscript out of range on the line that calculates PriceSplit whenever it encounters a blank cell.

View 9 Replies View Related

VLookup Function - Incorrect Results

Nov 10, 2011

I have a problem with VLOOKUP function and I am looking for a workaround.

SheetA I have a column of business names and another column of the category.

SheetB has a list of credit card transactions and a column of categories - The results obtained from incorrect results from SheetA...

View 7 Replies View Related

IF Logic Function - Greater Than Or Less Than With 3 Results

Aug 2, 2013

I'm trying to have three different possible results from one formula based on one cell.

If A1 is greater than 10 I want B1 show 5, AND if A1 is less than -10 I want B1 to show -5, AND if A1 is between 9 and -9 I want B1 to show the value of A1/2.

I've never used logic functions in excel before.

View 2 Replies View Related

Different Results When Using Forecast And Trend Function

Aug 29, 2013

I am forecasting some numbers and I wanted to see which function would be best suited for my task. I used the TREND function and then the FORECAST, I was expecting the same results but appeared to have slight differences.

View 2 Replies View Related

Isblank Function Erroneous Results

Sep 1, 2009

Using data of unknown origin in Excel I found Isblank was giving a FALSE result on some apparently blank cells while giving a TRUE result on others.

Even if I used TRIM and CLEAN functions on the offending data and pasted the resulting values back the the original locations, the Isblank result was still FALSE. Also, the font colour was not set to white or transparent.

However, if I selected the cell with the 'invisible' data, clicked in the Formula Bar and pressed Enter without entering any new data, the problem disappeared for that cell. The problem also disappeared if I selected the problem 'blank' cell and pressed delete.

Can anyone explain this 'invisible data' and tell me how I can detect it using a function or formula?

View 9 Replies View Related

Conditional IF AND Function Provide For 1 Of 3 Results

Jan 19, 2008

how to put together a function that will provide for me 1 of 3 results, (0, 1 or 2). Example Attached.

What I would like to do is have a function to have the results for the "Pts" (D) Column be either 0, 1 or 2 based on the following.

PM (D)<1.84 (F:10) = 2
PM (D)<2.25 (E:10), >1.84 (F:10) = 1
PM (D)>2.25 (E:10) = 0

View 2 Replies View Related

Index Function To Display Results In Same Cell

May 29, 2014

I'm currently using this formula:

=INDEX(B4:B64,MATCH(I5,A4:A64,0))

If I5's value is displayed more than 1 time in Column A, I want the information in Column B to appear in the same cell the formula is in in Column J

View 3 Replies View Related

Sort Two Columns Of Function Results Using Result Value?

Feb 4, 2013

How can I sort two columns of function results using the result value? Excel is trying to sort on the function in the cells rather than the results themselves.

View 9 Replies View Related

Look Up Function Is Coming Up With The Wrong Results On Several Items

Oct 16, 2009

The attached workbook contains a cell with validation list selection and a look up function. The validation list selection works fine, but the look up function is coming up with the wrong results on several items. Is this a bug or am I doing something wrong?

View 2 Replies View Related

Create List Of Results With Lookup Function?

Mar 16, 2012

I'm working on an invoice generator, and I want to add a "lookup by phone number" feature. I've got an invoice database with invoice info stored horizontally for past invoices. On a separate sheet, I want to be able to type in the phone number in range ("O11:Q11") and have a list of invoice numbers and dates matching that phone number appear in Columns R and S respectively.

Here is some workbook info:

Invoice generator is in 'phonelookup'
Invoice database is in 'invoice database' and the table is called CompInvoices
In CompInvoices, Invoice numbers are col1, dates are col2, and phone numbers are col7.

View 1 Replies View Related

Amending VBA Sub / Function To Pass Results To Other Subs

Feb 5, 2014

Basically someone has coded a VBA script to pull a users details from AD when a button is clicked, using the staff id as the search criteria.

I've amended the criteria so it uses Environ$(USERNAME) to find details of the current logged on user, but i am struggling to get the resulting information out of the Sub to be used in other Subs! It currently just fills a cell with the required info.

View 1 Replies View Related

Count Unique Results: Function &lt;&gt; Filter

Dec 27, 2007

Data: four variables A,B,C and D from A2:D6000

I want a count of unique D values
when A=xxx
and B=yyy
and C=zzz

I have named the A,B,C,D ranges as RangeA, RangeB, RangeC, RangeD

I have used the function

=SUM((RangeA="xxx")*
(RangeB="yyy")*
(RangeC="zzz")*

But what do I use to count-unique values of variable D ?

=SUM(IF(FREQUENCY(RangeD,RangeD)>0,1)) doesn't work.
=SUM(1/COUNTIF(RangeD,RangeD&"")) doesn't work either

They don't work because D can occur during different combinations of A,B and C. In other words, the D value of 'Smith' can, and does, occur when A is 1,2 or 3 and additionally when B is Pass, Fail, Withdrawn.

They "don't work" because I can use filters on A, B, C and D to see what the correct answer should be .. and the function doesn't return the correct answer.

I hope I've explained this ok - I've been searching on several excel-help websites for 2 days now and one of the days my client is going to want some results.

View 9 Replies View Related

Array To Match Several Results Within SUMPRODUCT Function

Aug 25, 2008

I'm using a formula (with the SUMPRODUCT function) within which I need to match the month & year from an array with 3 "true" possibilities...

Meaning that if data (month & year) from the array matches any of the 3 months & year of a specific quarter (for example July 08, August 08, September 08), the result of that section should be "True".

The data to be matched (any of the 3 months of each quarter) is drawn from a table header (showing every month of the year) by using this "monthly" formula:

TEXT(H7;"mm.yyyy") where H7 holds "01.07.2008" (but displays "Jul. 08") and returns "07.2008".

I'm trying to extend it to something like:

TEXT({H$7;I$7;J$7};"mm.yyyy") to match either July 2008 (H7), August 2008 (I7) or September 2008 (J7) for the 3rd quarter of 2008 but when I hit Enter, I get an error and H$7 is highlighted ("ctrl + shift + enter" doesn't help).

Here's an excerpt of the formula that works well for other queries on my worksheet:

=SUMPRODUCT(--(TEXT('Current update analysis'!$O$2:OFFSET('Current update analysis'!$O$2;(COUNTA('Current update analysis'!$B:$B)+20);"mm.yyyy")=TEXT({H$7;I$7;J$7};"mm.yyyy")); --('Current update analysis'!$k$2:OFFSET('Current update analysis'!$k$2;(COUNTA('Current update analysis'!$B:$B)+20)="ok"))

how I could/should structure the formula for it to work?

View 10 Replies View Related

Filter Function Not Returning Correct Results In The Code?

Mar 20, 2013

In an excel sheet, I am using a macro to filter. Macro code is as follows. When I run this macro, it returns 4 rows matching the criteria from 560 rows in the excel sheet.

VB:
ActiveSheet.Range("$A$1:$I$566").AutoFilter Field:=1, Criteria1:= _
">=11/11/2012 22:13", Operator:=xlAnd, Criteria2:="<=11/12/2012 6:47"

I want to use the same criteria in the vb.net code, to do same thru vb.net. But, when I run the same code in vb.net, it just returns only 1 row (1st row only).

VB:
[FONT=Consolas][SIZE=2][COLOR=#0000ff]xlsRange1.AutoFilter(Field:=1, Criteria1:=">=11/11/2012 22:13", Operator:=Excel.XlAutoFilterOperator.xlAnd, Criteria1:="<=11/12/2012 6:47")

This returns 1 instead of 4 expected.

View 2 Replies View Related

Index / Match Function To Count Criteria Results Once?

Jun 11, 2014

I've been trying to edit my index formula to only count an order number once even if the criteria for that result appear more than once. Attachment 324723

View 7 Replies View Related

Get AND Function To Return Back Results Other Than True And False

Mar 5, 2014

Here's my formula:

=AND([@[Tenure (Yrs)]]>=5,[@[2016 Sales]]>=150000)

(Where should I enter high and low? Do I need an if formula nested into it?)

I'm trying to get it to read if the customer reads both criteria which is they've been there 5 years and over 150000 sales =
High if not Low.

View 4 Replies View Related

Single Formula/Function Return Results To Multiple Cells

Aug 26, 2006

I've got an If statement in Excel which features several VLookups - I need the IF statement to return differing results to 2 different cells, is this possible?

In plain English, I'm looking for something like

If(Vlookup(A2, B2:D5, 4, False), C6="y" And D7="ok", "False")

Obviously this is a very crude example

View 3 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

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







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