Excel's SLOPE function on a non-continuous range?
The SLOPE function needs at least two contiguous X data points and two contiguous Y data points (two XY data points total) to calculate a slope. If your X data points are in column A and your Y data points are in column C, your formula should be something like... =SLOPE(C1:C2, A1:A2) --- EDIT --- If you are trying to use a non-contiguous range for the X data points and a non-contiguous range for the Y data points, the only thing I can suggest is to create a block of contiguous cells equal the non-contiguous cells e.g F1 = A1 F2 = A3 F3 = A5 G1 = B1 G2 = B3 G3 = B5 ... or something like that. You could put in F1 this... =OFFSET($A$1,ROW()*2-2,0) ... and drag/copy it down. It will fill the cells in column F with all the odd row cells from column A .
The If Function in excel?
Here's the MS reference material on the IF function. Without knowing what your spreadsheet looks like, I can't provide an exact answer. Also, I hesitate to do your homework for you. I'd recommend asking a friend in person. Get them to tell you how to do it (or give you hints), but do the actual computer work yourself. It's designed as a hands-on exercise to help you learn =)
How to use a nested IF function on excel 2013?
1) In C17 how do I use the nested IF functions to display the shipping costs for the option entered in cell B15. If the shipping option in cell B15 is blank, then cell C17 should be blank. (I put the labels and shipping costs in range D40:E42) 2) In cell C19, enter a formula to display the total cost of the product (price times quantity) plus shipping. In cell B12, enter 4. 3) In cell C19, modify the formula so that if the cell equals an error value (#Value!), the message Check Product ID, Quantity, or Shipping option is displayed. https://onedrive.live.com/redir?resid=E865E58EBDB94298%21120
I need help with excel IF function?
It states that "in cell F3, write an IF function tgat inserts the value 0.08 if the client is located in Washington and the value 0 if client is located elsewhere. Use the fill handle to copy the formula in cell F3 to the range F4:F16" The only thing i know how to do is the fill handle! Help would be very much appreciated, thank you in advance
In Microsoft Excel, is there a function to return the value "infinity"?
I want a function in Microsoft Excel that would return infinity in a formula. That means when i divide anything by this function the answer would be zero. Thanks
How to use IF function in EXCEL to check number of digits in cell?
=IF(LEN(A1)=7,"OK","Problem") Although that'll accept 12345.6, even though some people might think of as a 5 digit number, since it has the decimal point and another digit after the decimal point. You could also do: =IF(AND(A1>=1000000, A1<10000000), "OK","Problem")