Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula. Suppose youd like to plot the following equation. Here is an example of IF AND OR formula that tests a couple of OR conditions within AND.
Instead of typing the constants into your formula you can select the cells.
After you insert the equation the Equation Tools Design tab opens with symbols and structures that can be added to your equation. Dragging the AutoFill handle is the most common way to apply the same formula to an entire column or row in Excel. Whether youre adding up your. Grab the fill handle and drag it down to cover the whole column.