Question

14. The teacher has asked Vijay to
differentiate between the three formulas
written below with the help of suitable
descriptions. help him to do the following
assignment as he is new to MS Excel.
=A1+A2
=$A$1+$A$2
=$A1+A$2 *​

Answer 1

Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and you’ve got yourself a formula that’s much more powerful.

Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and you’ve got yourself a formula that’s much more powerful.In this tutorial we’re going to take a look at the basics of the AND and OR functions and then put them to work with an IF Statement. If you aren’t familiar with IF Statements, click here to read that tutorial first.