math

Can I use excel 2016 to calculate Kellys equation K% = W – [(1 – W) / R] W = 0.34 and R = 0.86 If so how do I do this? Please forgive me but I am a wiz at math or excel :confused:

Hi,I'm looking for a Vlookup formula where I am checking a table. If that value is found, then give me the value in a column that matches the data. Example: A B C D Class ID Class Matching...

Hi All, I've got a strange question here... I have a cell A1 that has the numbers '5/100' in it. I want cell A2 to calculate that to 5% I can't seem to make it work! Help Kind regards, Pharmacisticus

Hi, I have a problem translating this excel formula (actually the combination of two) into excel spreadsheet. Probably I do something wrong regarding the syntaxis for the natural log (ln()), as my math skills are a bit rusty... Does anybody have a clue how the excel-formula would look like...

Hi all, I haven’t been able to find an answer on this. I have apivot and I need a calculated item to consider the value in the previous column.Meaning: if Columns G and H were June and July respectively, I need the calculateditem result in Col H to consider a value in Col G in the math. Is...

All, Could you all help me figure out how to get this to converge. Or could someone get it to converge on their pc and help me with the options I need to change to get it to converge on my PC? I am wanting to set cell H28 to zero by changing the value in cell M10 . Based on basic math. I...

<tbody>#CACACA[/URL] "] A B C #CACACA[/URL] , align: center"]1 #C0C0C0[/URL] , align: center"]ID #C0C0C0[/URL] "]Subject #C0C0C0[/URL] , align: center"]score #CACACA[/URL] , align: center"]2 1000 Math 80 #CACACA[/URL] , align: center"]3 1001 English 45 #CACACA[/URL] , align: center"]4...

<tbody> ID Subject score 1000 Math 80 1001 English 45 1002 Math 60 1002 English 87 1001 English 50 1000 Chem 54 1001 Math 71 1002 Chem 83 </tbody> <tbody> ID Name Age 1000 matt 12 1001 john 15 1002 simon 16 </tbody> This solution needs to be a formula that must be...

I am having a very odd problem with Excel 365 Pro+ formula results. I have a complex cash flow modeling worksheet that includes 100+ columns of data in weekly buckets. The formulas in each column are circular/iterative and solve to a minimum cash balance, with the revolver paydown/drawdown...

Hi Guys, Need some help here. So I have a workbook with filename "Master Data" with tab sheets namely "Main File" and "Final". Main File Data look like this" <tbody> Name Stat 1 Stat 2 PrevStat Subject1 Subject2 Subject 3 Eve 9 6 10 Math Science PE Mon 7 5 15...

I could never get pictures to save. Anyway, I have a table (Table A): https://pasteboard.co/HpTLfSL.png and another table (Table B) https://pasteboard.co/HpTLsxl.png and I want to aggregate (Table B agg): https://pasteboard.co/HpTLGFn.png I can do this in power pivot. But then I want to...

Been inactive for years and just logged back in using my 2004 Password! Looking for some assistance on this sheet my wife sent this morning. Should be easy for you guys on this board. Pretty sure it can be accomplished with those hairy INDEX/MATCH functions but they are Greek to me! We need...

Hi everyone, there is a large amount of orders I receive everyday which Needed to be recorded into the master file, in contains of different category of course types. Is there a way that could look up the regular courses and copy the whole row down, and whenever new courses are registered...

I was thinking those who are skilled in excel often have a mind for math logic as well. Perhaps you can help me finish this equation? I am trying to calculate the live percentage difference between two targets in the cryptocurrency market in relation to realtime price changes. Entry: .02...

Is there a VBA option to convert a Table (table name is Tracking on sheet called Tracking) into a standard excel range? The table is in columns A-AE. The table will constantly grow, so there is no definante number for rows. On the other side. Is there a VBA option to convert a range into a...

I'm not really sure how to explain this... basically I get reports on student grades for tests/projects on different dates. THe report that's generated can export to excel but it's not the easiest to work with. I'd like to make a macro to convert this data to a different format (Like student...

I'm creating a spreadsheet to keep track of my hobby, sports betting. Of course, being a mediocre Excel nerd, I want to automate as much as possible, but now I'm running into a formula issue. I swear I'm so close, but now I need help from the pros. So here's what I have and what I'm looking for...

Ok so I have a large grid. I have an index match formula that is searching for the teacher & period and returning the course. I want to include a "check" in the formula that shows an error if the same teacher is has their name more than once for the same period. My formula currently in...

I have a list of classes, teachers, and periods. I need to sum the periods for each teacher when their name is typed in. The problem is that the data is not arranged in a 3x2 grid. eg Math 8 3 Joe Math 9 4 Joe Math 10 5 Sam Eng8 4 Lucy Eng 9...

Is there a way to create a formula that does the following... If C2<47.5 then C2*(?) as long as the result doesn't exceed 95.1 I'm trying to maximize the number of parts from a sheet. Max sheet size is 48 wide (a set dimension) by 95 long (a variable dimension). I have a formula to calculate...