All cells with Formulas showing up blank in read-only view
I have a workbook that I share with several other people in read-only mode in Excel Online. When they open the page, any cell with a formula just shows blank. Even simple ones like =Now(). If I open the book myself it updates and then shows up proper in read-only view, but after awhile they show up blank again. The workbook is being written to by an external script but everything showed up fine for months, this problem only showed up in the last week or so.
Formula IF not taking another formaula result as a value
Hi everyone, I would like to use the following formula (1): =IF([@[Unit Sold]]>[@Ecom];[@Ecom];[@[Unit Sold]]) knowing that [@[Unit Sold]] has the following formula (2): =IFERROR(VLOOKUP($B10;'Unit Sold W1-W25'!$A$1:$M$4932;3;FALSE);"0") Ideally I wanted the formula 1 to understand the value 0 of the formula 2 when it is, but it doesn't So I have my high value showing instead of the 0. I could copy past [Unit Sold]] as value, but Im trying to build an automated file so I would like to find another solution and keep the formula 2 in my cells Thanks in advance !Result of a formula not considered as a value
Hi everyone, I would like to use the following formula (1): =SI([@[Unit Sold]]>[@Ecom];[@Ecom];[@[Unit Sold]]) knowing that [@[Unit Sold]] has the following formula (2): =SIERREUR(RECHERCHEV($B10;'Unit Sold W1-W25'!$A$1:$M$4932;3;FAUX);"0") Ideally I wanted the formula 1 to understand the value 0 of the formula 2 when it is, but it doesn't So I have my high value showing instead of the 0. I could copy past [Unit Sold]] as value, but Im trying to build an automated file so I would like to find another solution and keep the formula 2 in my cells Thanks in advance !
Helping find the Beta (Variance and Covariance) between sets of data based on date and category
Hi Everyone, I have a large data set which involves the return for a category as well as its benchmark. I wish to find the correlation or beta between the two. The given formula is COVARIANCE.P(stock return, index return)/VAR.P (Index Return), however as i have large number of stocks (categories), i also have mutiple benchmark returns, which apply to different stocks. Is there a formula which will select the data for this formula by matching the two categories. Eg a domestic share to the domestic share index. I have attached an example and looking for any suggestions. Thank you kindly.Looking for help to find the sum of stock based on category, and also the assocaited return
Hi, I have data for a series of shares which will change depending on the fund. I have listed them as domestic shares, real estate, bonds etc. I am hoping to find a formula that will update the % of the portfolio that is in each class. I am also aiming to show the relevant benchmark return for each class, based on each asset. For example BHP is domestic shares, so show the benchmark return for domestic shares next to it. I have uploaded an example with the questions and desired answers. Can someone please assist. Kind regards,
