Excel Busn Math 11: Order Of Operations For Math

I am doing some testing and i need to do simple conversions on some data. The data has units in the same cell as numbers is it possible to make excel ignore text and just do math operations on the number in a cell?

I have a form with 3 textboxes, where the third textbox needs to be updated on the fly based on the value of second textbox being updated. I used the "Change" event to do this but I receive an error message #13. If I use the "Afterupdate" event, it works ok, but I need it in the change event. Any help on what I am missing.

This data input from user is normal numbers, for example:
textbox1 = 8
textbox2 = 7
then, textbox3 = (8-7)/60
this is what I did

textbox3.value = (textbox1.value - textbox2.value) / 60

Help please,

I have a Matriz on Worksheet(3) (6x6 for example), and I'd like to print this Matriz on Worksheet(2), but just part of it, cause the user is gonna select part of the Matriz( for example: the user select a matriz3x3 from the original one 6x6, to be printed on worksheet(2)). I've created a UserForm, and in the UserForm I'm using RefEdit. My problem is: How do I print this Matriz on Worksheet(2), once my Matriz is variable, defined by the user?

Thanks!

Hey everybody,
I am fairly new to excel,If ANYONE CAN HELP ME WITH THIS FORMULAR I WILL GREATLY APRECIATE IT!!! Thanks in advance

I am ready to kill myself, as it should be sooo easy and yet I cannot make this formular work.
Here is how my spread sheet looks like
A B C
1 RMSE Pea 0.97
2 ME Pea 0.56
3 RMSE Brown 0.51
4 ME Brown 0.76

this spread sheet is 200 rows, so I needed to created another table summarizing ME and RMSE for each author from column B.

A B C
6 MRSE ME
7 Pea
8 Brown

I guess what I am trying to accomplish is: if RMSE and Pea then repoprt 0.97
her is my function and it works for the first row only and returns FALSE for the rest



=IF($A$1:$A$4=$B$6,IF($B$1:$B$4=$A7,$C$1:$C$4,"")

I know I can find may wary around by using sumif function in this case, but I am struggling with this format when is do not need to do any math operation but only report a cell
I also have to use nested array b/c I'll be sorting this data later

Hi,

How do i perform mathematical operations on date and time? In one cell i have a value of
"2/1/2011 9:00:00 PM" and i would like to minus the value "2/1/2011 10:00:00 PM". I'am expecting to get a -1 (hour) as a result.

Any help will be greatly appreciated

Hi All,

I have a sheet with two tables in it. Both have 16 columns.
The first column is the name of a site, then columns 2-15 are the page views for each day over a two week period, finally column 16 is the total for the two weeks.
The second table is exactly the same except the values in columns 2-15 conform to time on site.
What I want to do is create a macro (i think) that looks in column 1 of table A sees the entry in row 1, attempts to find the same value in column 1 of table B (becasue the sites are not in the same order in both tables) then muliply the value in column 16 of table A with the corresponding entry in column 16 in table B. I would then like to iterate through the rest of the values in column 1 of table A until all entries have been multiplied.
Something like this

Table 1
Site Page View Page View Total foo.com 5312 234 5546 boo.com 1245 23 1268 abc.com 78 35 113


Table 2
Site Time Time Total abc.com 2.1 1.3 3.4 foo.com 43.1 4.6 47.7 boo.com 12 43.4 55.4

where we multiply the value for total of foo.com in table 1 by the total value of foo.com in table 2.

Thanks,
Bob

Hello,

I am trying to perform operations such as mulitplying the values of a filtered column by 2 but am having a lot of issues with macros. For example, I tried making a seperate column of the result of multiplying the other column by 2 then pasting values back on the original column after a filter but it only pastes the first filtered value. Can someone post some sample code to do something like this? Thanks

I have created a graphed curve in excel based on data I have entered. I now want to take the formula for the graph, and use it as an excel computation where I can plug in X and get Y, or plug in Y to get X. However, when i try to enter in variations of these equations, I end up with just the wrong answers (based on the data that went into the graph to begin with.

The formulas excel gives me are these:

y = -1.1288x 3 + 23.209x 2 - 166.76x + 430.07 (preferred), or alternately


y = 579.38e -0.574x


So how can I enter this formula so that I can have it pull x from a cell and spit out the answer for y (and the reverse)?

I need a formula that does this. I have a base number of 300 seconds and want to add 30 seconds to it for every number over 1 so the output would be like this
input 0 and get 0 out
input 1 and get 300 out
input 2 and get 330 out
input 3 and get 360 out
input 4 and get 390 out
and so on. I can't for the life of me get the math down. Can someone please help.

I use a lot of math equations in my excel books. I would prefer to use correct symbols (primarily greek alpha characters) on the worksheet. Anyone have a useful and effective way of doing this?