A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
what is the excel formula for market volatility? by Dyn
anybody knows the formula??
March 16th 11 07:54 AM
by Jakes Norm Go to last post
8 2,525
Calculating Sortino Ration (Downside Deviation) by TimH
I am trying to write a formula to calculate the Sortino Ratio defined as (Expected (Observed) Return - Minimum Acceptable Return(MAR))/Downside Deviation. ...
March 15th 11 01:21 AM
by Moti wig Go to last post
7 8,229
Conditional formatting backwards compatibility question by Vladimir Shchelkunov
Hi All I'm having some issues with backwards compatibility of a file with conditional formatting built in 2007. I have a cell (M63) that has 2 conditions...
March 15th 11 01:20 AM
by Vladimir Shchelkunov Go to last post
0 367
Signature question by ElaineT
I am trying to set up a workbook with multiple tabs and two signature lines at the bottom. The idea is that my boss can read, sign and close my work as...
March 12th 11 08:15 AM
by martincrow Go to last post
1 1,538
using the 'Convert' function by M-A H
Wish to convert CBM to FT3 andy suggestions on what the formula should be..? TY
March 11th 11 01:29 PM
by Bijender Singh Go to last post
7 2,363
Path Too Long fixer by dan gurt
http://LongPathTool.com Don’t you just hate it when you get error messages that say “The path is too long” or “Error cannot delete file: cannot read from...
March 10th 11 10:37 PM
by dan gurt Go to last post
0 208
Path Too Long fix by dan gurt
http://LongPathTool.com Do you have error messages?, like : Path too long. Error cannot delete file: cannot read from source file or disk Cannot delete file:...
March 10th 11 04:13 AM
by dan gurt Go to last post
0 311
optimization by dschneiderch
I will try to explain clearly. I have a bi-linear curve and I would like to know where the breaking point is. Looking at a graph of the ordered data (highest...
1 235
Count by Skip[_2_]
I have about 500 sales entries. Using autosort, I pull out all Mondays (they are scattered though out the 500) I want then to count then number of Monday...
March 8th 11 05:29 PM
by David8 Go to last post
3 378
time window calculation by SteveR
Thanks Joe. I did know about making that substitution but must have messed it up due to being in a hurry. I just did it more carefully and all you formulas...
March 8th 11 04:53 AM
by SteveR Go to last post
0 246
time window calculation by SteveR
I goofed up my question. You are right the data is in column A. The intermediate formula I am trying to eliminate "mod(a1),1" is in Column M.
March 8th 11 02:40 AM
by joeu2004 Go to last post
1 281
time window calculation by SteveR
I copy and paste data from another program into a spreadsheet daily. I have aboutn 250+ rows of date and times in Column A in this format 2/28/2011 4:56:46...
March 8th 11 12:05 AM
by joeu2004 Go to last post
1 317
setting scale for graphs by namsilat
Instead of having to enter numbers manuallly, is it possible to point the Max and Min values under Scale for a graph to specific cells in the spreadsheet?
March 6th 11 06:27 PM
by namsilat Go to last post
2 313
Protection by Esradekan
Hope someone can help. Is there any way that a 'protection' can be put on an excel workbook, that will allow that workbook to be run on a specific machine...
March 6th 11 07:34 AM
by Esradekan Go to last post
2 273
Calculating age of death by Annie
Hi I work in a hospital and have to calculate what exact age someone is when they die. I have birth date and date of death. How can I calculate in total...
(Multi-page thread 1 2)
March 5th 11 04:59 AM
by Ron Rosenfeld[_2_] Go to last post
16 2,621
Need array formula to ignore hidden values by NickH
I have the following array formula dragged across several columns, which works a treat, but the data may be filtered by various criteria and there's the...
March 4th 11 02:12 PM
by NickH Go to last post
1 535
Formula Question by Lefty33
Is there a way I can take dates from one worksheet and have them highlight the appropriate dates on a calendar worksheet? If so, can anyone tell me how?
March 4th 11 10:59 AM
by tarquinious Go to last post
1 1,725
Trying to add column headings to array formula by Pierre
On Mar 3, 6:36*pm, Pierre > wrote: > Located this code that would be perfect for us. *Only thing is, that > it starts at cell A1 and leaves no...
March 4th 11 04:15 AM
by Pierre Go to last post
0 363
Basic Probabilities UDF Function Help by Joe Smith03
Ive written a very basic UDF function to calculate 2 probabilities given several potential variables, but I keep receiving this error message and I am entirely...
March 3rd 11 09:52 PM
by Joe Smith03 Go to last post
3 1,628
Help with Xecel Sheets by Markzas
Hello, I am trying to copy a value of one cell from one spreadsheet to a cell of another spreadsheet. and below is what i have comeup with so far. Can...
March 3rd 11 06:12 PM
by tarquinious Go to last post
2 1,653
Post New Thread


Display Options
Showing threads 2001 to 2020 of 88501
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.