αž‚αžŽαž“αžΆ

αž€αŸ†αžŽαžαŸ‹β€‹αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž‚αžŽαž“αžΆβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈ αŸ” αž€αŸ†αžŽαžαŸ‹β€‹αž₯αžšαž·αž™αžΆαž”αžβ€‹αž“αŸƒβ€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈβ€‹αž‡αžΆαž˜αž½αž™ αžŸαŸαž…αž€αŸ’αžŠαžΈβ€‹β€‹β€‹αž™αŸ„αž„β€‹αžŠαžŠαŸ‚αž›β€‹αŸ— αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž€αžΆαž›β€‹αž”αžšαž·αž…αŸ’αž†αŸαž‘ αž…αŸ†αž“αž½αž“β€‹αžαŸ’αž‘αž„αŸ‹β€‹αž‘αžŸαž—αžΆαž‚ αž“αž·αž„ αž”αžΎβ€‹αž€αžΆαžšβ€‹αžŸαžšαžŸαŸαžšβ€‹αž‡αžΆβ€‹αž’αž€αŸ’αžŸαžšβ€‹αž’αŸ† ឬ αž’αž€αŸ’αžŸαžšβ€‹αžαžΌαž…β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž‚αž·αž αž“αŸ…β€‹αž–αŸαž›β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€β€‹αž€αŸ’αž“αž»αž„β€‹αžŸαž“αŸ’αž›αžΉαž€ αŸ”

β€‹β€‹αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž”αŸ’αžšαžΎβ€‹β€‹αž”αž‰αŸ’αž‡αžΆβ€‹αž“αŸαŸ‡...

Open a spreadsheet document, choose - LibreOffice Calc - Calculate.


αžŸαŸαž…αž€αŸ’αžαžΈβ€‹β€‹αž™αŸ„αž„β€‹αžŠαžŠαŸ‚αž›αŸ—

αž€αŸ’αž“αž»αž„β€‹αž•αŸ’αž“αŸ‚αž€β€‹αž“αŸαŸ‡β€‹αž’αŸ’αž“αž€β€‹αž’αžΆαž…β€‹αž€αŸ†αžŽαžαŸ‹β€‹αž–αŸ’αžšαŸ†αžŠαŸ‚αž“β€‹αž…αŸ†αž“αž½αž“β€‹αž”αŸ’αžšαž αŸ‚αž›β€‹αž“αŸƒβ€‹αž‡αŸ†αž αžΆαž“ αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž’αž“αž»αžœαžαŸ’αžβ€‹αž€αŸ†αž‘αž»αž„β€‹αž–αŸαž›β€‹αž€αžΆαžšβ€‹αž‚αžŽαž“αžΆβ€‹αžŠαžŠαŸ‚αž›β€‹αŸ—Β αŸ” αž›αžΎαžŸβ€‹αž–αžΈβ€‹αž“αŸαŸ‡β€‹αž‘αŸ€αž αž’αŸ’αž“αž€β€‹αž’αžΆαž…β€‹αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹αž€αž˜αŸ’αžšαž·αžβ€‹αž—αžΆαž–β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαž½αžœβ€‹αž“αŸƒβ€‹αž…αž˜αŸ’αž›αžΎαž™Β αŸ”

β€‹αž’αŸ’αžœαžΎβ€‹αžŠαžŠαŸ‚αž›β€‹αŸ—

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹αžαžΆβ€‹αžαžΎβ€‹αžšαžΌαž”αž˜αž“αŸ’αžβ€‹αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αžŸαŸαž…αž€αŸ’αžαžΈβ€‹β€‹αž™αŸ„αž„β€‹αžŠαžŠαŸ‚αž›β€‹αŸ— (αžšαžΌαž”αž˜αž“αŸ’αžβ€‹αžŠαŸ‚αž›β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž’αŸ’αžœαžΎβ€‹αž˜αŸ’αžαž„β€‹αž‘αŸ€αžβ€‹αžβ€‹αŸ—β€‹αž‚αŸ’αž“αžΆ αž‘αžΆαž›αŸ‹β€‹αžαŸ‚β€‹αž”αž‰αŸ’αž αžΆβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αžŠαŸ„αŸ‡αžŸαŸ’αžšαžΆαž™) αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž‚αžŽαž“αžΆβ€‹αž”αž“αŸ’αž‘αžΆαž”αŸ‹β€‹αž–αžΈβ€‹αž…αŸ†αž“αž½αž“β€‹αž€αžΆαžšβ€‹αž’αŸ’αžœαžΎβ€‹αž˜αŸ’αžαž„β€‹αž‘αŸ€αžβ€‹αž‡αžΆαž€αŸ‹αž›αžΆαž€αŸ‹β€‹αž˜αž½αž™Β αŸ” αž”αžΎβ€‹αž”αŸ’αžšαž’αž”αŸ‹ αž€αžΆαžšβ€‹αž’αŸ’αžœαžΎβ€‹αžŠαžŠαŸ‚αž›β€‹αŸ— αž˜αž·αž“β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αžŸαž˜αŸ’αž‚αžΆαž›αŸ‹ αž“αŸ„αŸ‡αžŸαŸαž…αž€αŸ’αžαžΈβ€‹αž™αŸ„αž„β€‹αžŠαžŠαŸ‚αž›β€‹αŸ—β€‹αž˜αž½αž™β€‹αž€αŸ’αž“αž»αž„β€‹αžαžΆαžšαžΆαž„ αž“αžΉαž„β€‹αž”αžŽαŸ’αžαžΆαž›β€‹αž²αŸ’αž™β€‹αž˜αžΆαž“β€‹αžŸαžΆαžšβ€‹αž€αŸ†αž αž»αžŸβ€‹αž˜αž½αž™Β αŸ”

αž§αž‘αžΆαžšαž αžŽαŸ αŸ– αž‚αžŽαž“αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž’αžΆαžαž»β€‹αžŠαŸ„αž™β€‹αž‚αŸ’αž˜αžΆαž“β€‹αž–αž“αŸ’αž’αž”αž“αŸ’αžαŸ‚αž˜

  1. αžœαžΆαž™β€‹αž’αžαŸ’αžαž”αž‘ 'αžαž˜αŸ’αž›αŸƒβ€‹αž›αž€αŸ‹' αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ A5 αž’αžαŸ’αžαž”αž‘ 'Net' αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ A6 αž“αž·αž„ αž’αžαŸ’αžαž”αž‘ 'αžαž˜αŸ’αž›αŸƒβ€‹αž–αž“αŸ’αž’β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž“αŸ’αžαŸ‚αž˜' αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ A7Β αŸ”

  2. αž₯αž‘αžΌαžœβ€‹αžœαžΆαž™β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž›αž€αŸ‹ (αž§αž‘αžΆαž αžšαžŽαŸ 100) αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ B5Β αŸ” αžαž˜αŸ’αž›αŸƒβ€‹αžŸαž»αž‘αŸ’αž’β€‹αž‚αž½αžšβ€‹αžαŸ‚β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ B6 αž αžΎαž™β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž–αž“αŸ’αž’β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž“αŸ’αžαŸ‚αž˜ αž‚αž½αžšβ€‹αžαŸ‚β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ B7Β αŸ”

  3. αž’αŸ’αž“αž€β€‹αžŠαžΉαž„β€‹αžαžΆ αžαž˜αŸ’αž›αŸƒβ€‹αž–αž“αŸ’αž’β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž“αŸ’αžαŸ‚αž˜β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž‚αžŽαž“αžΆβ€‹αž‡αžΆ 'net price times 15%' αž αžΎαž™β€‹αžŠαŸ‚αž›β€‹αž’αŸ’αž“αž€β€‹αžˆαžΆαž“β€‹αžŠαž›αŸ‹β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŸαž»αž‘αŸ’αž’β€‹αžŠαŸ„αž™β€‹αž”αž“αŸ’αžαž™β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž–αž“αŸ’αž’β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž“αŸ’αžαŸ‚αž˜ αž–αžΈβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž›αž€αŸ‹Β αŸ” αžœαžΆαž™β€‹αžšαžΌαž”αž˜αž“αŸ’αž =B5-B7 αž€αŸ’αž“αž»αž„ B6 αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž‚αžŽαž“αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŸαž»αž‘αŸ’αž’ αž αžΎαž™β€‹αžœαžΆαž™β€‹αžšαžΌαž”αž˜αž“αŸ’αž =B6*0.15 αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ B7 αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž‚αžŽαž“αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž–αž“αŸ’αž’β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž“αŸ’αžαŸ‚αž˜Β αŸ”

  4. αž”αžΎαž€β€‹αž€αžΆαžšβ€‹αž’αŸ’αžœαžΎβ€‹αžŠαžŠαŸ‚αž›β€‹αŸ— αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž‚αžŽαž“αžΆβ€‹αžšαžΌαž”αž˜αž“αŸ’αžβ€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ αž”αžΎβ€‹αž–αž»αŸ†β€‹αž“αŸ„αŸ‡β€‹αžŸαŸ„αžβ€‹αžŸαžΆαžšβ€‹αž€αŸ†αž αž»αžŸ 'αž™αŸ„αž„β€‹αž‘αŸ…β€‹αžαŸ’αž›αž½αž“β€‹αž―αž„' αž›αŸαž…β€‹αž‘αžΎαž„β€‹αž€αŸ’αž“αž»αž„β€‹αžšαž”αžΆαžš αžŸαŸ’αžαžΆαž“αž—αžΆαž–Β αŸ”

A

B

αŸ₯

αžαž˜αŸ’αž›αŸƒβ€‹αž›αž€αŸ‹

100

៦

αžŸαŸ†αžŽαžΆαž‰αŸ‹

=B5-B7

៧

αž–αž“αŸ’αž’

=B6*0.15


αž‡αŸ†αž αžΆαž“

αž€αŸ†αžŽαžαŸ‹β€‹αž…αŸ†αž“αž½αž“β€‹αž’αžαž·β€‹αž”αžšαž˜αžΆβ€‹αž“αŸƒβ€‹αž‡αŸ†αž αžΆαž“β€‹β€‹αž’αŸ’αžœαžΎβ€‹αžŠαžŠαŸ‚αž›β€‹αŸ—Β αŸ”

αž—αžΆαž–β€‹αž•αŸ’αž›αžΆαžŸαŸ‹αž”αŸ’αžαžΌαžšβ€‹αž’αž”αŸ’αž”αž”αžšαž˜αžΆ

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αž—αžΆαž–β€‹αžαž»αžŸβ€‹αž‚αŸ’αž“αžΆβ€‹αžšαžœαžΆαž„β€‹αž›αž‘αŸ’αž’αž•αž›β€‹αž‡αŸ†αž αžΆαž“β€‹αž“αž·αž™αžΆαž™β€‹αž‘αžΎαž„β€‹αžœαž·αž‰β€‹αžβ€‹αž‚αŸ’αž“αžΆΒ αŸ” αž”αžΎβ€‹αž›αž‘αŸ’αž’αž•αž›β€‹αž“αŸƒβ€‹αž€αžΆαžšβ€‹αž“αž·αž™αžΆαž™β€‹αž‘αžΎαž„β€‹αžœαž·αž‰β€‹αž‘αžΆαž”β€‹αž‡αžΆαž„β€‹αžαž˜αŸ’αž›αŸƒβ€‹αž•αŸ’αž›αžΆαžŸαŸ‹αž”αŸ’αžŠαžΌαžšβ€‹αž’αž”αŸ’αž”αž”αžšαž˜αžΆ αž”αž“αŸ’αž‘αžΆαž”αŸ‹β€‹αž€αžΆαžšβ€‹αž“αž·αž™αžΆαž™β€‹αž‘αžΎαž„β€‹αžœαž·αž‰β€‹αž“αžΉαž„β€‹αžˆαž”αŸ‹Β αŸ”

αž€αžΆαž›β€‹β€‹αž”αžšαž·αž…αŸ’αž†αŸαž‘

αž‡αŸ’αžšαžΎαžŸβ€‹αž€αžΆαž›β€‹αž”αžšαž·αž…αŸ’αž†αŸαž‘β€‹αž…αžΆαž”αŸ‹αž•αŸ’αžαžΎαž˜ αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž€αžΆαžšβ€‹αž”αž˜αŸ’αž›αŸ‚αž„β€‹αžαžΆαž„β€‹αž€αŸ’αž“αž»αž„β€‹αž–αžΈβ€‹αžαŸ’αž„αŸƒβ€‹αž‘αŸ…β€‹αž‡αžΆβ€‹αž›αŸαž αŸ”

12/30/1899 (αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜)

αž€αŸ†αžŽαžαŸ‹ 12/30/1899 αž‡αžΆβ€‹αžαŸ’αž„αŸƒβ€‹αžŸαžΌαž“αŸ’αž™Β αŸ”

01/01/1900 (StarCalc 1.0)

αž€αŸ†αžŽαžαŸ‹ 1/1/1900 αž‡αžΆβ€‹αžαŸ’αž„αŸƒβ€‹αžŸαžΌαž“αŸ’αž™Β αŸ” αž”αŸ’αžšαžΎβ€‹αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž“αŸαŸ‡β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈ StarCalc 1.0 αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž’αžΆαžαž»β€‹αž€αžΆαž›β€‹αž”αžšαž·αž…αŸ’αž†αŸαž‘Β αŸ”

01/01/1904

αž€αŸ†αžŽαžαŸ‹ 1/1/1904 αž‡αžΆβ€‹αžαŸ’αž„αŸƒβ€‹αžŸαžΌαž“αŸ’αž™Β αŸ” αž”αŸ’αžšαžΎβ€‹αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž“αŸαŸ‡β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈ αžŠαŸ‚αž›β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž“αžΆαŸ†αž…αžΌαž›β€‹αž€αŸ’αž“αž»αž„β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž”αŸ’αž›αŸ‚αž€β€‹αŸ—Β αŸ”

αž”αŸ’αžšαž€αžΆαž“αŸ‹β€‹αžαž½β€‹αž’αž€αŸ’αžŸαžšβ€‹αžαžΌαž…β€‹αž’αŸ†

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹αžαžΆβ€‹αžαžΎβ€‹αž‰αŸ‚αž€β€‹αžšαžœαžΆαž„β€‹αž’αž€αŸ’αžŸαžšβ€‹αž’αŸ† αž“αž·αž„ αž’αž€αŸ’αžŸαžšβ€‹αžαžΌαž…β€‹αž€αŸ’αž“αž»αž„β€‹αž’αžαŸ’αžαž”αž‘β€‹αž¬β€‹αž‘αŸ αž“αŸ…β€‹αž–αŸαž›β€‹αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”β€‹αž˜αžΆαžαž·αž€αžΆβ€‹αž€αŸ’αžšαž‘αžΆ αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ αŸ– αžœαžΆαž™β€‹αž’αžαŸ’αžαž”αž‘ 'Test' αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ A1 αž“αž·αž„β€‹αž’αžαŸ’αžαž”αž‘ 'test' αž“αŸ…β€‹αž€αŸ’αž“αž»αž„ B1 αŸ” αž”αž“αŸ’αž‘αžΆαž”αŸ‹β€‹αž˜αž€β€‹αžœαžΆαž™β€‹αžšαžΌαž”αž˜αž“αŸ’αž "=A1=B1" αž“αŸ…β€‹αž€αŸ’αž“αž»αž„αž€αŸ’αžšαž‘αžΆ C1 αŸ” αž”αŸ’αžšαžŸαž·αž”αž”αžΎβ€‹αž”αŸ’αžšαž’αž”αŸ‹ αž”αŸ’αžšαž€αžΆαž“αŸ‹β€‹αž’αž€αŸ’αžŸαžšαžαžΌαž…αž’αŸ† αžαŸ’αžšαžΌαžœαž”αžΆαž“αž‚αžΌαžŸβ€‹αž’αžΈαž€ αž“αŸ„αŸ‡ FALSE αž“αžΉαž„β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ αž”αžΎβ€‹αž˜αž·αž“β€‹αžŠαžΌαž…αŸ’αž“αŸαŸ‡β€‹αž‘αŸ TRUE αž“αžΉαž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“αž”αž„αŸ’αž αžΆαž‰β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„αž€αŸ’αžšαž‘αžΆ αŸ”

note

αž’αž“αž»αž‚αž˜αž“αŸβ€‹αž’αžαŸ’αžαž”αž‘ EXACT αžαŸ‚αž„αžαŸ‚β€‹αž”αŸ’αžšαž€αžΆαž“αŸ‹β€‹αžαž½β€‹αž’αž€αŸ’αžŸαžšβ€‹αžαžΌαž…β€‹αž’αŸ† αžαž»αžŸβ€‹αž–αžΈβ€‹αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž€αŸ’αž“αž»αž„β€‹αž”αŸ’αžšαž’αž”αŸ‹β€‹αž“αŸαŸ‡Β αŸ”


warning

Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.


αž…αŸ†αž“αž½αž“β€‹αž‘αžŸαž—αžΆαž‚β€‹αžŠαžΌαž…β€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹αžαžΆβ€‹αžαžΎβ€‹αž’αŸ’αžœαžΎβ€‹αž€αžΆαžšβ€‹αž‚αžŽαž“αžΆ αžŠαŸ„αž™β€‹αž”αŸ’αžšαžΎβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž”αž„αŸ’αž‚αžαŸ‹β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž€αŸ’αž“αž»αž„β€‹αžŸαž“αŸ’αž›αžΉαž€β€‹αž¬β€‹αž‘αŸΒ αŸ” αž‚αŸ†αž“αžΌαžŸαžαžΆαž„β€‹αž“αžΉαž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž‡αžΆαž˜αž½αž™β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰Β αŸ” αž”αžΎ αž…αŸ†αž“αž½αž“β€‹αž‘αžŸαž—αžΆαž‚β€‹αžŠαžΌαž…β€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰ αž˜αž·αž“β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αžŸαž˜αŸ’αž‚αžΆαž›αŸ‹ αž“αŸ„αŸ‡β€‹αž›αŸαžβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž‚αžαŸ‹ αž”αŸ‰αž»αž“αŸ’αžαŸ‚β€‹αž–αž½αž€β€‹αžœαžΆβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž‚αžŽαž“αžΆβ€‹αžαžΆαž„β€‹αž€αŸ’αž“αž»αž„ αžŠαŸ„αž™β€‹αž”αŸ’αžšαžΎβ€‹αž›αŸαžβ€‹αž˜αž·αž“β€‹αž”αž„αŸ’αž‚αžαŸ‹Β αŸ”

αž›αž€αŸ’αžαžŽαŸˆβ€‹αžœαž·αž“αž·αž…αŸ’αž†αŸαž™β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ ​​"=" αž“αž·αž„ "<>" αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž’αž“αž»αžœαžαŸ’αžβ€‹αž‘αŸ…β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž‘αžΆαŸ†αž„αž˜αžΌαž›

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αž›αž€αŸ’αžαžŽαŸˆβ€‹αžœαž·αž“αž·αž…αŸ’αž†αŸαž™β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€β€‹αžŠαŸ‚αž›β€‹αž’αŸ’αž“αž€β€‹αž€αŸ†αžŽαžαŸ‹β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž˜αž»αžαž„αžΆαžšβ€‹αž˜αžΌαž›αžŠαŸ’αž‹αžΆαž“β€‹αž‘αž·αž“αŸ’αž“αž“αŸαž™ Calc αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž•αŸ’αž‚αžΌαž•αŸ’αž‚αž„β€‹αž“αž·αž„β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž‘αžΆαŸ†αž„αž˜αžΌαž›β€‹αž™αŸ‰αžΆαž„β€‹αž–αž·αžβ€‹αž”αŸ’αžšαžΆαž€αžŠΒ αŸ” αž–αŸαž› αž›αž€αŸ’αžαžŽαŸˆβ€‹αžœαž·αž“αž·αž…αŸ’αž†αŸαž™β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ = αž“αž·αž„ <> αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž’αž“αž»αžœαžαŸ’αžβ€‹αž‘αŸ…β€‹αž”αŸ’αžšαž’αž”αŸ‹β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž‘αžΆαŸ†αž„αž˜αžΌαž› αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αžŸαž˜αŸ’αž‚αžΆαž›αŸ‹ LibreOffice Calc αž’αŸ’αžœαžΎβ€‹αž₯αžšαž·αž™αžΆαž”αžβ€‹αžŠαžΌαž… MS Excel αž–αŸαž›β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž€αŸ’αž“αž»αž„β€‹αž˜αž»αžαž„αžΆαžšβ€‹αž˜αžΌαž›αžŠαŸ’αž‹αžΆαž“β€‹αž‘αž·αž“αŸ’αž“αž“αŸαž™Β αŸ”

.* αž€αŸ’αž“αž»αž„β€‹αž‘αžΈαžαžΆαŸ†αž„β€‹αžαžΆαž„β€‹αž€αŸ’αžšαŸ„αž˜ αŸ–

αž›αž‘αŸ’αž’αž•αž›β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ αŸ–

win

αžšαž€ win αž”αŸ‰αž»αž“αŸ’αžαŸ‚β€‹αž˜αž·αž“β€‹αž˜αŸ‚αž“ win95, os2win ឬ upwind

win.*

αžšαž€ win αž“αž·αž„ win95 αž”αŸ‰αž»αž“αŸ’αžαŸ‚β€‹αž˜αž·αž“β€‹αž˜αŸ‚αž“ os2win ឬ upwind

.*win

αžšαž€ win αž“αž·αž„ os2win αž”αŸ‰αž»αž“αŸ’αžαŸ‚β€‹αž˜αž·αž“β€‹αž˜αŸ‚αž“ win95 ឬ upwind

win.*

αžšαž€ win, win95, os2win αž“αž·αž„ upwind


αž”αžΎ αž›αž€αŸ’αžαžŽαŸˆβ€‹αžœαž·αž“αž·αž…αŸ’αž†αŸαž™β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ ​​"=" αž“αž·αž„ "<>" αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž’αž“αž»αžœαžαŸ’αžβ€‹αž‘αŸ…β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž‘αžΆαŸ†αž„αž˜αžΌαž› αž˜αž·αž“β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž’αŸ’αžœαžΎβ€‹αž²αŸ’αž™β€‹αž”αŸ’αžšαžΎβ€‹αž”αžΆαž“ αž“αŸ„αŸ‡β€‹αž›αŸ†αž“αžΆαŸ†β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ "win" αžŠαžΎαžšβ€‹αžαž½β€‹αžŠαžΌαž…αž‡αžΆβ€‹αž›αŸ†αž“αžΆαŸ†β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€ ".*win.*" αžŠαŸ‚αžšΒ αŸ” αž›αŸ†αž“αžΆαŸ†β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€β€‹αž’αžΆαž…β€‹αžŸαŸ’αžαž·αžβ€‹αž“αŸ…β€‹αž‘αžΈαžαžΆαŸ†αž„β€‹αžŽαžΆβ€‹αž€αŸβ€‹αž”αžΆαž“ αž“αŸ…β€‹αž–αŸαž›β€‹αžŸαŸ’αžœαŸ‚αž„αžšαž€β€‹αž‡αžΆαž˜αž½αž™β€‹αž’αž“αž»αž‚αž˜αž“αŸβ€‹αž˜αžΌαž›αžŠαŸ’αž‹αžΆαž“β€‹αž‘αž·αž“αŸ’αž“αž“αŸαž™ CalcΒ αŸ”

warning

Enable whole cell match for spreadsheets that need to be interoperable with Microsoft Excel.


Enable wildcards in formulas

Specifies that wildcards are enabled when searching and also for character string comparisons.

warning

Enable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


αž’αŸ’αžœαžΎβ€‹αž²αŸ’αž™β€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž“αž·αž™αŸαžβ€‹αž”αŸ’αžšαžΎβ€‹αž”αžΆαž“β€‹αž€αŸ’αž“αž»αž„β€‹αžšαžΌαž”αž˜αž“αŸ’αž

Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.

warning

Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


No wildcards or regular expressions in formulas

Specifies that only literal strings are used when searching and also for character string comparisons.

warning

Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


αžšαž€β€‹αžŸαŸ’αž›αžΆαž€β€‹β€‹αž‡αž½αžšβ€‹αžˆαžš αž“αž·αž„ αž‡αž½αžšβ€‹β€‹αžŠαŸαž€β€‹αžŠαŸ„αž™β€‹β€‹αžŸαŸ’αžœαŸαž™β€‹β€‹αž”αŸ’αžšαžœαžαŸ’αžαž·

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αž’αŸ’αž“αž€β€‹αž’αžΆαž…β€‹αž”αŸ’αžšαžΎβ€‹αž’αžαŸ’αžαž”αž‘β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆβ€‹αžŽαžΆβ€‹αž˜αž½αž™β€‹αž‡αžΆβ€‹αžŸαŸ’αž›αžΆαž€β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž‡αž½αžšβ€‹αžˆαžšβ€‹αžαžΆαž„αž€αŸ’αžšαŸ„αž˜β€‹αž’αžαŸ’αžαž”αž‘ αž¬β€‹αž‡αž½αžšβ€‹αžŠαŸαž€β€‹αž‘αŸ…β€‹αžαžΆαž„αžŸαŸ’αžŠαžΆαŸ†β€‹αž“αŸƒβ€‹αž’αžαŸ’αžαž”αž‘Β αŸ” αž’αžαŸ’αžαž”αž‘β€‹αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž˜αžΆαž“β€‹αž™αŸ‰αžΆαž„β€‹αž αŸ„αž…β€‹αžŽαžΆαžŸαŸ‹β€‹αž–αžΆαž€αŸ’αž™β€‹αž˜αž½αž™ αž“αž·αž„β€‹αžαŸ’αžšαžΌαžœβ€‹αžαŸ‚β€‹αž˜αž·αž“β€‹αž˜αžΆαž“β€‹αžŸαž‰αŸ’αž‰αžΆβ€‹αž”αŸ’αžšαž˜αžΆαžŽβ€‹αžœαž·αž’αžΈβ€‹αžŽαžΆβ€‹αž˜αž½αž™β€‹αž‘αŸΒ αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ αŸ– αž€αŸ’αžšαž‘αžΆ E5 αž˜αžΆαž“β€‹αž’αžαŸ’αžαž”αž‘ "Europe" αŸ” αžαžΆαž„β€‹αž€αŸ’αžšαŸ„αž˜β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„αž€αŸ’αžšαž‘αžΆ E6 αž‚αžΊβ€‹αž‡αžΆβ€‹αžαž˜αŸ’αž›αŸƒβ€‹ ៑០០ αž αžΎαž™β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ E7 αžαž˜αŸ’αž›αŸƒ ្០០ αŸ” αž”αŸ’αžšαžŸαž·αž“αž”αžΎβ€‹αž”αžΆαž“αž‚αžΌαžŸβ€‹αž’αžΈαž€β€‹αž”αŸ’αžšαž’αž”αŸ‹ αžšαž€αžŸαŸ’αž›αžΆαž€β€‹αž‡αž½αžšαžˆαžš αž“αž·αž„β€‹αž‡αž½αžšαžŠαŸαž€β€‹αžŠαŸ„αž™β€‹αžŸαŸ’αžœαŸαž™β€‹αž”αŸ’αžšαžœαžαŸ’αžαž· αž’αŸ’αž“αž€β€‹αž’αžΆαž…β€‹αžŸαžšαžŸαŸαžšβ€‹αžšαžΌαž”αž˜αž“αŸ’αžβ€‹αžŠαžΌαž…αžαžΆαž„β€‹αž€αŸ’αžšαŸ„αž˜β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž€αŸ’αžšαž‘αžΆ A1: =SUM(Europe) αŸ”

αž€αŸ†αžŽαžαŸ‹β€‹αž‘αžŸαž—αžΆαž‚β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž›αŸαžβ€‹αž‘αžΌαž‘αŸ…

αž’αŸ’αž“αž€β€‹αž’αžΆαž…β€‹αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹β€‹αž…αŸ†αž“αž½αž“β€‹αžαŸ’αž‘αž„αŸ‹β€‹αž‘αžŸαž—αžΆαž‚β€‹αž’αžαž·αž”αžšαž˜αžΆβ€‹αžŠαŸ‚αž›β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž‡αžΆβ€‹αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜ αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž‘αžΌαž‘αŸ… αŸ” αž”αŸ’αžšαžŸαž·αž“αž”αžΎβ€‹αž˜αž·αž“β€‹αž”αžΆαž“β€‹αž”αžΎαž€β€‹αž‘αŸβ€‹αž“αŸ„αŸ‡ αž€αŸ’αžšαž‘αžΆβ€‹β€‹αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž›αŸαžβ€‹β€‹αž‘αžΌαž‘αŸ…β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž‡αžΆβ€‹αžαŸ’αž‘αž„αŸ‹β€‹αž‘αžŸαž—αžΆαž‚β€‹αž‡αžΆβ€‹αž…αŸ’αžšαžΎαž“β€‹αž‡αžΆβ€‹αž‘αž‘αžΉαž„β€‹αž‡αž½αžšβ€‹αžŠαŸαž€β€‹αžŠαŸ‚αž›β€‹αž’αž“αž»αž‰αŸ’αž‰αžΆαž αŸ”

αžαŸ’αž‘αž„αŸ‹β€‹αž‘αžŸαž—αžΆαž‚

αž€αŸ†αžŽαžαŸ‹β€‹αž…αŸ†αž“αž½αž“β€‹αž‘αžŸαž—αžΆαž‚β€‹αžŠαŸ‚αž›β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αž„αŸ’αž αžΆαž‰β€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž…αŸ†αž“αž½αž“β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž›αŸαž αž‘αžΌαž‘αŸ… αŸ” αž›αŸαžβ€‹αž“αžΉαž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž‡αžΆβ€‹αž…αŸ†αž“αž½αž“β€‹αž”αž„αŸ’αž‚αžαŸ‹ αž”αŸ‰αž»αž“αŸ’αžαŸ‚β€‹αž˜αž·αž“β€‹αžšαž€αŸ’αžŸαžΆαž‘αž»αž€β€‹αž‡αžΆβ€‹αž…αŸ†αž“αž½αž“β€‹αž”αž„αŸ’αž‚αžαŸ‹β€‹αž‘αŸαŸ”

Please support us!