Before moving on, let's explore some more formulas to make sure you understand the order of operations by which Excel calculates the answer.

5*3/2 | Multiply 5*3 before performing the division operation because the multiplication sign comes before the division sign. The answer is 7.5. |

5/3*2 | Divide 5/3 before performing the multiplication operation because the division sign comes before the multiplication sign. The answer is3.333333. |

5/(3*2) | Perform the operation in parentheses (3*2) first and divide 5 by this result. The answer is 0.833333. |

5+3-2 | Add 5+3 before performing the subtraction operation because the addition sign comes before the subtraction sign. The answer is 6. |

5-2+3 | Subtract 5-2 before performing the addition operation because the subtaction sign comes before the addition sign. The answer is 6. |

5-2*3 | Multiply 2*3 before performing the subtraction operation because the multiplication sign is of a higher order than the subtaction sign. The answer is-1. |

(5-2)*3 | Perform the operation in parenthesis (5-2) first and then multiply by 3. The answer is 9. |

## 0 comments:

## Post a Comment