I can accomplish the same task using a database function (i.e. dsum), a
math function (i.e. sumif), and an array formula. If my goal is to
make the spreadsheet run as efficiently (fast) as possible, which
should I choose? Let's assume this is a very large set of data, and if
pertinent, the equation will be used frequently.
Also, I've heard array formulas in large volumes can slow down a
spreadsheet considerably. Why is this the case? What is the best
source for finding out information like this?
Thanks for your help.
Hi,
When I write the following in cell A1, =1&")", I get
1)
in cell A1.
What formula should I write in cell A2 so that I can get,
2)
in cell A2.
I tried the following in cell A2, =a1 + 1, but I get an error.
Can anyone help me find the correct formula.
Does anybody have/know where to find a list of the math functions that VBA has? I know a couple already such as Sin() and Cos() but would like a comprehensive list. I'm using Excel 2003 and do not have the option to install additional libraries.
Thanks a lot.
Johhny.
I need to sum column L then divide that by 36 then multiply that by the sum of column N. How can this be accomplished with a formula?
Has anyone ever encountered a source of (ideally free!) add-ins for more arcane math functions such as elliptic integrals? I know that engineering add-ins deal with Bessel functions but once in an eternity I have to go above and beyond that. Thanks.
Is there any way to do math functions in an Access table?
This is what I am trying to do:
Field A = Field B - Field C
Thanks!
NYcowgirl
I've been trying to figure out what I'm doing wrong here.
I want a cell to subtract itself from 10 and then divide it by 2...
and maybe I'm typing it out wrong...
=Sum(Cell#-10)/2
So basically, if I have 20, it subtracts from 10 and then divide by 2.
Dah, what's wrong with it!? T.T
Hi All,
Im having a problem on using wildcards. The catch is to account all values with the same name (EX: john, john34, john5)
I came up with this function:
=SUMPRODUCT((data!A2:A13=A2)*(data!C2:C13))/COUNTIF(data!A2:A13,'fill up'!A2)
Is it possible to insert a wildcard on a range? In the given fuction-- data!A2:A13
I tried these two functions below but it always returns 0.
=SUMPRODUCT((data!A2:A13&"*"=A2)*(data!C2:C13))/COUNTIF(data!A2:A13,'fill up'!A2)
=SUMPRODUCT((left(data!A2:A13)&"*"=A2)*(data!C2:C13))/COUNTIF(data!A2:A13,'fill up'!A2)
Any suggestions or comments on this?
HI all, I am having problems getting this formula to work and a few years ago I would have solved this in minutes. I don`t use excel anymore in my work, so it is no longer second nature to me when it comes to advanced calculations. Although, my problem will be simple to some of you I`m sure.
I have a cell that would have a value of
10:15:30:00
for example
I need for my formula to be able to add a number to this a give me the result in the same format which is 2 numbers followed by a colon, and so on, so always
xy:za:bc:de
so if my entered value is
30:00
my resulting value needs to be 10:16:00:00
59 is the highest value ( like time ) to that is why the result is not 10:15:60:00
if my entered value was 1:00:00
then result would be
10:16:30:00
If no one can solve this in the preferred way through regular math, then I would also be grateful for the functions that allow me to split up the cell in the background
so I could extract the first 2 characters, in this case 10, then another cell could have the 4th and 5th characters, then 7th 8th, then 10th and 11th
then i could use another formula to turn this into 10153000 and that way use regular math to add a number and then use further functions to split it up again in the format I need.
The date and math functions won't work in the expression builder, and I'm getting the error message 'Invalid data format' each time I build the first new query upon opening the database. This database is replicated if that makes a difference. What is causing the problem and how can I fix it? Thanks.
