Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.
Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1
Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1
Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1
I hope this resolves the question. If not, please let me know.
364 views
Usually answered in minutes!
hi thank you for ur explanation... pls help me what if i multiply,divide, add and subtract like this
multiply A1 UP TO A5 HOW TO DO IT?
DIVE A1 UP TO A5 ?
ADD A1 UP TO A5 ?
ETC.....
THANKS A LOT IM HOPING UR RESPONCE
×