significance

If I have the values 1,2,3,4,5 in column A, values a,b,c,d,e in column B, values e,f,g,h,i in column C, then if I type (in any cell on the worksheet) the formula: = Offset(A1, 1, 1) I get the value of b because it starts at cell A1, moves 1 row down, then 1 column right to cell B2. What...

I am familiar with this type of IF(AND =IF(AND(G11=10,H11=20),"Yes","No") Can someone please explain what this is doing? =IF(AND(A1="a")*(B1=10)*(C1=30),D1,E50) What is the significance of the multiply? Thanks

I'm using this formula in my spreadsheet =IF(ISBLANK(DI4),CEILING.MATH(DH4,4),"") But can I get the 'significance' reference (example here is multiples of '4') to reference a cell instead that I can use to change the value to round by in ? e.g quickly change from Rounding by 4 to rounding by 5...

Hello all, I am currently researching the impact of the equity valuation by the Shiller P/E ratio on different equity strategies on an equity index. I made a scatter plot where I plotted the ten year forward annualized returns with the corresponding equity valuation at that moment. For the...