Tan To The Power Of Minus 1
Dec 10, 2008How can i produce "tan to -1 " in excel ?
View 9 RepliesHow can i produce "tan to -1 " in excel ?
View 9 RepliesHow to get Power-query and Power-pivot for Excel 2010?
View 9 Replies View Relatedim building a fairly intricate workbook at the minute but it is starting to slow down significantly lately as ive added more fromula's and sheets. I was hoping to make it even bigger but it looks like i might be stoped in my tracks. I have a reasonaby powerful computer and excel 2003. Does anyone know a way i could increase the capacity of this one particular workbook as it will be used by many people to enter data daily.
View 3 Replies View RelatedTo find the power ( i.e. ^ n) when you have other variables.
Mathematical Perspective as well as through EXCEL..
Ex: 5^n = 125
We know that 5^3 = 125,
Now if I have been given the value 5 and 125 , then how do i get the answer 3 ( i.e ^ n) value...
I need to solve a slightly complex issue and therefore need help for the above requirement as well as to get the "n" value..
I am trying to do a nested if formula but I can't get it to work.
The condition is: If value in cell R5 >0 then get the value in cel X29 on power 4.
=IF(R5>0,POWER(X29,4)
how can I type numbers to the power of something Say 12 to the power of 3. I want the 3 to be smaller and up off the line is that possible
View 3 Replies View RelatedI am trying to fit a cooling graph with a trendline and I have found the power line to fit the best, as well as corresponding with Newton's law of cooling. However, I am not savvy enough to discuss how similar or dissimilar the two equations are!
the resulting equations from two different curves are as follows:
y=4305 x^-0.87733
y=4025 x^-0.91004
both fits have an R^2 of 0.996.
I am analyzing two scenarios of cooling the same object with three variables, one intended (the extraction of energy using water flow in one case, and no extraction in the other) and the others not under my control: different starting temperatures and different ambient temperatures. I need to understand if these are generally the same curve, or how very different are they? is there any statistical way to represent their relationship?
I have a question about coping table from exel into ppt, is this posible or not,
PS: i just need to copy a specific range of cells ex. A1 g17 into a slide in pp.
I am trying to write a routine (via two comboboxes) that will enable users to select a choice of charts from one of three possible worksheets and have the charts on the selected sheet copied to PowerPoint. My difficulties are these:
a. I cannot determine how to pass the selections to Excel (see b. as well)
b. In some instances my charts are actually groups of a chart and a picture. how I should reference these? They are obviously not ChartObjects: when I use the macro recorder all I get is a range.
I have a string of n pairs and want to check various combination of that string.
Example: Pairs 58 78 15
Since I know I have 3 pairs (but it can be 2 or 4), I know the number of combination I want to test, ie 2 power 3 = 8 combinations. How can I program a code creating the various strings, ie 587815, 587851, 588715, 588751, 857815, 857851, 858715, 858751 ?
This is what I have so far (not much):
Public unique_pair 'number of pairs provided by another macro
Public mystring 'provided by another macro
Sub make_guess()
Dim number_of_combination, i
number_of_combination = 0
number_of_combination = 2 ^ unique_pair
For k = 1 To number_of_combination
'how to generate the various string ????
Next k
End Sub
I have created a Power Pivot Chart with Stacked Column chart. Made one axis as Secondary Axis and the axis is Clustered Column, but it is overlapped with Stacked bars.
Is there any easy way to solve this issue, apart from creating 2 dummy columns and making it work.
I've been trying to get power query to search a list of parcel numbers on an assessor site: [URL]. The problem I'm getting, every time you put in a different parcel number, you get the same URL for the results. I want to extract just a few pieces of information for each parcel search, but I can't initiate a search through excel. I'm thinking the problem is in the Data source settings. How can just get it to show me the assessors page results for a single parcel search in excel?
View 5 Replies View RelatedI need to be able to send my selected range of cells (to include: the spreadsheet background, colored cells and all values contained) to Power Point for a daily product. I found this great VBA online and would like to use it but the problem is I keep getting funny results. It doesn't matter what cells I select I keep getting a extra margin on the left side and top of the pasted product in power point. I then have to crop the results... I have looked at the macro (from my noodie eyes) and cannot seem to find a way to adjust this added on margin.
View 5 Replies View RelatedI am using the following code to Open a presentation, and run a macro. Everything works fine, but I would like it also to Save the presentation and Close it.
View 7 Replies View Relatedhow to suspend/hibernate some specific sheets in one workbook , to free cpu power?
View 5 Replies View Relatedi would like to write vba to fill a "chess Board" Matrix (8X8) With Powers Of 2...
starting with 2^0 and ending with 2^63...
(i suppose, click a button/icon and have the numbers fill in/populate...)
Have a system that runs 8 monitors on one computer. 4 are very large screens. Creates a lot of heat and uses much power.
Is there a way to dim the screens brightness in VBA. Looked all over and can't find any code.
Not really looking for a screensaver as they can cause interrup problems etc if I have programs running for hours. And I can't just turn off some screens as then desktop icons placements get scrambled.
Just want to dim screens with a macro, then undim it. Don't need to have it linked to the mouse movement, but that might be nice too.
I tried a macro that said "Dim MyScreens" but nothing happened.
Is it possible to modify the windows power settings in excel vba. I have this example, but it doesn't do anything.
Sub testPOWERCFG()
CreateObject("WScript.Shell").Run "POWERCFG /CREATE Custom1", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-ac 15", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-dc 10", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /SETACTIVE Custom1", 0, False
End Sub
I need some code to create and activate a scheme whereby everything is on and also some code to revert back to the default settings on the machine.
Using Excel 2013.
Trying to create a Calculated Column in a table to put Expense in 1 of 4 categories
I came up with =CALCULATE(sum([TotalExpense]),FILTER(factExpense,factExpense[ExpnseType]="Sundries"))
But that is returning total instead of a total for each record What did I miss?
This works for the first Calculated column: =CALCULATE(sum([TotalExpense]),FILTER(dimExpense,dimExpense[Type]="Sundries"))
But as soon as I copy the formula to the next column and update the type to "Wines_Spirits" I get
A circular dependency was detected
Found the answer on SQLBI website I added a unique id to each row and in Table Behavior in the Data Model set the Unique_ID as the Row_Identifier
[URL]
Using Excel 2013.
I am trying to get DistinctCount from a field if another field in the same table is greater than zero.
PowerPivot DAX -COUNTIF
[Code] .....
The count returned includes all not just values greater than zero. How can I get just values greater than zero?
I want to create a report using power pivot while creating the relationship between the linked tables, power pivot is throwing error "The relationship cannot be created because each cilumn contains duplicate values. Select at least one column that contains only values"
View 1 Replies View RelatedI need to have all of my number be "x10^-6", but Excel wants to make them, for instance, 7.66x10^-3, when I need it to read "7660x10^-6". How can I force excel to do this?
View 3 Replies View RelatedI have part if the code here’s
PHP
Range("f" & indexI + 1).Value = Format(Strl, "00:00")
to return value = time formats
How do I modify it to + 0.1 minus?
Sample
IF the return value = 12:00:00
Now I wanted = 12:00:01
Trying to work out the formulas for placing plus minus variables above and below a cell as per worksheet attached. right hand side of the page
View 2 Replies View RelatedI use a formula that has a date in it 11/15/13 for example. Then I have a formula that calculates "days" (15), but I want to subtract one. How do I do that?
View 2 Replies View RelatedHere is my formula.
=If(Sheet1!J5=$J$4,0,(Sheet1!$J$4-Sheet1!J5)*Sheet1!$J$1)
It is perfect, except it doesn't have one final step. What I need it to do
is be able to do that ONLY if it is greater than or less than by a specified
amount. So there needs to be a modification of ... Sheet!J5<> (but by 100 or
any other number that I set) $J$4,...
Assuming the first date is in A1, and the second date is in B1, in standard dd/mm/yyyy form, my current formula is =B1-A1-1.The '-1' is due to the fact that if a patient stays for 10 days, they will only spend 9 nights in the hospital. (Bed Nights).The problem is, the formula is stretched in the total column from, say C1 to C50. Each one of these has, or will have, a number of days in it.However, due to having th '-1' in the formula, empty rows that are yet to have a patients details inputted have a -1 where I need a 0. The only reason I need to change this is because I need a running total of the bed nights of all the patients.I think the formula I'm after is something along the lines of; 'If cell B2 is empty, input 0. If B2 has a date, use formula 'B2-A2'
View 9 Replies View RelatedI want to save phone no as +99 9876543210 in excel 2003 on my xp pro machine. But if i give a + sign in the cell, some blue dotted rectangle shows up and everything messes up.. I think it is treating it as a formula or something... how can i save this in the cell. tell me in detail if you are going to tell me about macros or vb code as I don't know how to insert code or program macros.
View 3 Replies View RelatedWith out using Conditional Formatting, how can I check a cells value if it can fall within a range of +-.002?
I have this code but it seems to have limitations.
=AVERAGE(INDEX(E5:IV5,LARGE(IF(E5:IV5<>"",COLUMN(E5:IV5)-COLUMN(E5)+1),5)):INDEX(E5:IV5,MATCH(9.99999999999999E+307,E5:IV5)))
I have this formula where it averages the last five numbers in a collumn, but I want to average the last 5 numbers less the max and min number.