In Excel, the formula =SUMPRODUCT(A1:A3, B1:B3) multiplies corresponding components and returns the sum. If A1=2,A2=3,A3=4 and B1=1,B2=2,B3=3, result is:
Explanation:
Long Text (formerly Memo) can store up to 65,536 characters. Short Text stores up to 255. Hyperlink is a type of Short Text, OLE Object stores binary data.
No comments yet. Be the first to start the discussion!