Ренат Шагабутдинов

Google Таблицы. Это просто. Функции и приемы


Скачать книгу

несколько элементов в условии формулы, скажем, адрес ячейки и знак >= или формулу и текст, используйте амперсанд (&)

      Конец ознакомительного фрагмента.

      Текст предоставлен ООО «ЛитРес».

      Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.

      Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.

/9j/4AAQSkZJRgABAQEAeAB4AAD//gAcU29mdHdhcmU6IEFkb2JlIEltYWdlUmVhZHn//gN+WE1MOmNvbS5hZG9iZS54bXA6IDw/eHBhY2tldCBiZWdpbj0iPyIgaWQ9Ilc1TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzOCA3OS4xNTk4MjQsIDIwMTYvMDkvMTQtMDE6MDk6MDEgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9InV1aWQ6MjJhZmU2OTUtYjlkMC00N2E1LWJhOTgtMzQ4MTRiYmMxYTk3IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOjc3OTY2RTFGQTQ3QjExRTc5NzhGRjE3RDA2QjkxODdFIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOjc3OTY2RTFFQTQ3QjExRTc5NzhGRjE3RDA2QjkxODdFIiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE3IChXaW5kb3dzKSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOjI1MmU4NWZlLTMwZjEtMjg0OC1hZGNmLTY5MmQwMjY5YzM1YyIgc3RSZWY6ZG9jdW1lbnRJRD0iYWRvYmU6ZG9jaWQ6cGhvdG9zaG9wOjQ5ODkzNmNkLTVkZGYtMTFlNy04YjgyLWE3MmMzMDYzY2ZkZCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/bAEMACgcHCAcGCggICAsKCgsOGBAODQ0OHRUWERgjHyUkIh8iISYrNy8mKTQpISIwQTE0OTs+Pj4lLkRJQzxINz0+O//bAEMBCgsLDg0OHBAQHDsoIig7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7O//AABEIAkgB3wMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/APUdd8QWnh9LFruOZxfXsdnH5Sg4d84JyRxwfU+1atcT8Tf9R4Z/7GG1/k9dtQBnap4h0fRGjXVNTtrNpQSizSBSwHUgVn/8J/4R/wChisP+/wAKqz4k+K1vG6qyrokhGRnrMn+FdFcmxs7eS5uvs8EMY3PJJhVUepJ6UAY3/Cf+Ef8AoYrD/v8ACl/4T/wj/wBDFYf9/hTtD8U+GPEc8sGk31rcTQsQ0YXaxA7gEAlfccVqJLpsl09oklq1xGMvCpUuo9x1FAGT/wAJ/wCEf+hisP8Av8KT/hYHhDOP+EisM/8AXYVFY+JEvdf/ALK/4R65jUO+b1ghtyg+4yuDht3TaORznoa2Vu9Ia5+yrcWRnzt8oOm7PpjrQBmDx94RP/Mxaf8AjOK6AEMAQQQeQRWH4wt4P+EL1v8AdRj/AIl8/O0f88zV7QpDL4f06RvvNaxE/XYKAL9FclN8SdFjkulS01W4W1keN5YLF3QlThsMBjjFblnr2l3un2t9HeRJDeIrQ+awQtu6DB7n0oA0aKguL60tGjW5uoYGlOIxJIFLn0GetNl1Cyt7hbea8t45nxtjeVQzZ6YBOTQBZoqvLfWduJTNdwRiHb5peQDZu6Zz0z2zSte2i3a2bXUIuWGVhMg3keu3rQBPRRRQAUVy+p/EDSNM1S605rbUrmWz2/aGtbNpEiyN3JHsc1uWWq6fqNvb3FneRTR3SeZCVbl1HUgdeO/pQBcoqtJqNjDbi4lvLeOEttEjSqFJ9M5xng1NDNFcRLLDIksbDKujAg/QigB9FFY+v+J9P8OLbfbEuZZbtykMNtCZXcgZOAPQUAbFFY+heKNM8Qx3H2VpYZrUgXFvcxmKWLIyCynoCOQaunVtNEMUx1C1EUxIiczLtcjrg55/CgC3RVT+1tN+ytdf2ha/Z1bY0vnLsDemc4z7U6fUbG1iSa4vbeGOQZR5JVUN9CTzQBZoqFru2UqGuIgXQuuXHzKOpHt71GNT08vDGL62L3ChoV81cyA9CvPI+lAFqiiigAorP1nXdL8PWLXuq3sVrCOhc8ufRR1Y+wo0bXdL8QWQvNKvYrqE4yUPKn0YdQfY0AaFFV4b+zuIDPDdwSxK20yJICoPpkd6RdRsXt5Lhby3aGJiskglUqhHUE5wDQBZoqNriFJI43mjV5c+WpYAvjk4HeohqNi0s0K3tuZIAWlQSrmMDqWGeB9aALNFVINW026lWG31C1mkddypHMrFh6gA9Kt0AFFFciPiZoDXaQhL8wvc/Zhd/ZH8gvnbjf8AWgDrqKge+tI7pLSS6hS4cZSFpAHYew6mg3toEdzdQhY38tz5gwrf3T6HkcUAT0VAb21CO5uYQqP5bEyDCt/dPoeRxT454Zt/lSo/lsVfawO1h1B9DQBJRVWTUrCKCKeS9t0imIEcjSqFcnsDnmrVABRRWZca/YWviG00KVpBeXkTyxAISpC9cnt0NAGnRWPZ+KdIvtX1DS4LoGfTmRbhiMIGbgKG6E5GMevFaTXlqnnb7mJfIG6XLgeWMZy3px60ATUVUfVtNiERk1C1QTLvj3TKN6+o55FB1XTRbLcnULUQN92Xzl2nnHBzjrxQBboqIXNuXlQTxloADKu8ZjyMjd6cc80R3MEztHFPHI6gMyq4JAPQn60AS0VWfUbGO0+2Pe2622cecZVCdcfezjrUgubcyRxieMvKu6Nd4y49QO4oAloqnJrGmRECTUbRCylgGnUZAOCevTIqxDPDcwrNBKksTjKujBlYexFAHGfE7/j38M/9jDa/yeu2rifid/qPDP8A2MNr/J67egDlZP8AkrMH/YEk/wDRy0fEDSr3U9MsHtLU30dlqEV1c2QIzcxLnKgHhjyDg8HFI/PxZhHpob/+jlrq6APHtBt7nXdZVrHS7yB7TxJPqEl7Pb+T5MHeAZ5LNwCvbjNZ2jXVjJ4k0Ca0tbPTZhqrJLaQwytdRBt4P2i4c5JJ/hxyPoa9ypojQMzBFBbliB1oA8O8Ni5Ft4PuLgm3sbDVJoIIiDiUfO8k5PbBwoHsxqfTLTTxZ+HNVjso1muvFTeXdiHDzRFn2/N1K5x19K9rKqRggY+lII0CqoRQF+6MdPpQBj+Mv+RJ1z/sHz/+gGrPh3/kWtL/AOvOL/0AVW8ZDPgrXP8AsHz/APos1Z8Pf8i3pn/XnF/6AKAOL8ITg+CvFzZfCahfkcHgbc8VyMTeGFMX/CRQpK8nha0SyUoWJfaQQuOjkgYNe5AADAAFZdv4es7bxFda4jy+fdQJC8ZYeWAh+UgY6/jQB5DrwC2JsdZsrWHVV0SJTcahby3NxdSGM4SBc7UKnhn655IPNVNaNnP9sa6vLSG5m0Wxe3W7tDcT3T+T0ifqjE4BPcnPavfCiMyuVBZfukjkfSkaKNmVmjUsvQkcigDxrUDEPGF5fatZuNIh/sx9UspnLFC0RVHkOPnVGOGXueecVS8UXVn/AGrqb/ZbPTb2DV0YqYpZb2QB1zL5xOIoyCMBRjnFe5lFOcqDnrkdaDGhYsUXcRgnHJHpQA6iiigDyTUr7TbXxx4pTUvFN74fDNCY47Y4E48kAtgqcn6YqnZx6qZ/BFtFYraalcabc2yME2fZY8gCfb3bZlsHqT717I8MUhBeNGI7soNOwM5xzQB4ZpFz4ft9I8H6frM9sLOGa9uZku0OGj3OkZZcHljyM/3TXe/CGWCTwDAsE0b+XcTqyp/AfMJAI7cEHHoRXVRaRYw6xcaskGLy5iSKWTcfmVc446d6bpui6fpEt5JY24ia+na4nO4nfIep56fQUAX64L4kzW9vqvhmW71GbSrdbmbffw8PD+6IABwQNx45Fd7TXRXXa6hh6EZoA8auEnvdF8YPo95ea1ZSral9RZf3su1h5sQYAblCZPAGMkc5rV1C28Gah4C8Sz6BpYe2to3kjmeBvJEpTBaHd0IwM4A5xXqCIsahUUKo6ADApFijSPy1RVT+6BgflQB5Pra6NpmleFom0fS7W2uLbz2vb2B2tYpGjXdmJcB5CBxu9KwoTYjSfDYv7uytoYptSj8zUbAzRJ86FV8on5TjkDPFe7NGjqFZFZQQQCMgYpHijkXa8asOuGGaAPDntriXQfDMNurhk02/3xOG33tsrqWVCQSm9N23jgHHcVD4rvdFubPU20uzsNPCxQyWO61lku50CqweInAhjAzyP7pz1r3naMg4GR09qb5Ue7d5a527c47en0oAZaOJLOFwxYNGpDE5zx1qakpaAPOfiDYXlvq13rcljNfWL6JPZRmFBI1nM2T5m3rgjgsOnfiudbTdYvvDGoaxpOm3lnGdDtbNgE8uW9dXQySBepAjDKCeoPGa9oooA8P8Qf2Nd6b4il8JxBdCGl24uPKQpCbgToVwD/GI85+ozzR4g/sSfS/EUnhaIJoh060hlMcbLEbn7QuOD1YIRn9ea9b1/wAO2XiLQ59HujJDb3BVnNuQjZDBvQjqB2rSSJEj2AZHcn+I+p96APHbV7258a+GpLt2f+x5ZtIK7TmeWKJi0i+gbKgd+M1Q0ObTrnxJ4d8i1060EtzLBdWNvbyNJGrqw2XEz8uxORtI7Gvc8A446dKaI41JIRQWOSQOp9aAOC8BaPo8XibxLNb6XaxSWWpGO3dYArRL5YBCnsOvT1969ApAACSABnr70tAFe+vrbTbGa+vJlht4ELySN0UCvFrbxBon/CAaTp76vbreyazHdTRlm/cqZix3HGOAQT+NezarpdnrWmT6bfxebbXC7ZE3EZGc9RyOlR6loun6tpMulXtuJLSZAjxglcgYI5HPYUAeN+L7izOp61ss7TT76HUkdQ0Ust9Nh1PnLKTiGPGCMcdu4qXV4Lk2XiiSG6hSxHiVRJaG1JkkcunzCXPy9+MevrXtSQxJt2xqNq7Acc7fTNO2qQRtHJyeOtAHieowzm18RyrdRJYL4pAmtGtS0jsZE+YS54HXjHr61b07XrjRde1yzsZobmS612dX0T7O32idGODIsnYYBYZGMA8817DtXBG0cnJ4pPKj8zzPLXf03Y5/OgDwi3it10vRZdWvLOy05tF2W8t/pzXURk8xzIFGRtkxtORyQBXr3guJ4fB+mxyXN1clYcCW6hMUjDJxlSSRxgDnpitl4o5ECPGrKDkAqCAafQAV5v48uNRtfH2inSbYz6hdWM9vaHOFhkYrmRuDkKpJx7V6RSUAeLatpltosuu6VbFVNtNo6m4eIvvk3MWldf4yS2SO/Skv4Zo9a8QrqUq3iQ6vpkmrTRW5jje2CtuzHz8oOM9c9a9p2qSTtGTjnHp0oKqQQVB3DByOtAHkfim28KXPwsv77Q9KYQ290EtJp4G/ilQsYi3IjOSOMDqMVP4ltfB+j/ESzh12ytINIj0RvIhEP7tZDKxPyqOpBbHufXFeqiNAgjCKEAwFA4ArLk8OWUvidfELvMboWn2Qxlh5ZTdu5GOufegDySWx1zT/AA7pkn2eUXfiexOkTCX5Sr+Z+5d/UmHK+oCird2s2h+PNbj0oMsU8VrocSKDlHkgURynjouw+9em3fhm2vvE1prlzc3MrWaEQWrOPJRzkeZtx97Bxn6VsAAEkAZPU+tAHhVjbpB4a8Mpd3VrFplrLfRTT3dkbm2E/mnZvTIGSucE9Oa1NMtHbVPCEOjawpmeO/a3vZ9PYL5eQQqxlshMbtpJ6H8K9feNJEKOisjdVIyDShVGMKPlGBx0oA8NhsdLl+F+kXUun2806a2Lcytb4JQzMSvTIUj+H8K9tsrK1060S0sraK2t487IokCquTk4A9yam2rjG0YznGO9LQBzPjjRLvWrTSms2gD6fqcN6yTPs8xUDZUHB5Oe/FP/AOEh1rOP+Eb/APKjD/jWnrGPsi5xjzB1+hrITbvXG3r6UAYd1DN4t8cx6fqKXmkC3015R9ivlDyZkUfMydh6H61p/wDCt7D/AKDviH/wZvVPR9v/AAtaYrj/AJBJ/wDRi13lAHH/APCt7D/oO+If/Bm9H/Ct7D/oO+If/Bm9dhRQBx//AArew/6DviH/AMGb0f8ACt7D/oO+If8AwZvXYUUAcc3w1050ZH1vxAyMMMrak5DDuCO4q2ngt40CR+KfEKqOg+1ocfmldNRQBzX/AAh0v/Q1+If/AAKj/wDiKP8AhDpf+hr8Q/8AgVH/APEV0tFAHNf8IdL/ANDX4h/8Co//AIij/hDpf+hr8Q/+BUf/AMRXS0UAc1/wh0v/AENfiH/wKj/+Io/4Q6X/AKGvxD/4FR//ABFdLRQBzX/CHS/9DX4h/wDAqP8A+Io/4Q6X/obPEP8A4FR//EV0tFAHNf8ACHS/9DZ4h/8AAqP/AOIo/wCEOl/6GzxD/wCBUf8A8RXS0UAc1/wh0v8A0NniH/wKj/8AjdH/AAh0pGP+Er8Q/wDgUn/xFdLRQBzI8GyqMDxX4i/G7Q/+yUv/AAh0v/Q1+If/AAKj/wDiK6WigDmj4NlIwfFfiL8LtB/7JSDwbIOnivxF/wCBaH/2SumooA5r/hDpf+hr8Q/+BUf/AMRR/wAIdL/0NfiH/wACo/8A4iulooA5r/hDpf8AobPEP/gVH/8AEUh8GSnr4s8RfhdoP/ZK6aigDmR4NlHTxZ4i/G7Q/wDslL/wh0v/AENfiH/wKj/+IrpaKAOa/wCEOl/6GzxD/wCBUf8A8RR/wh0v/Q2eIf8AwKj/APiK6WigDmT4MlPXxZ4i/wDAtB/7JSjwbKB/yNfiH/wKT/4iulooA5r/AIQ6X/obPEP/AIFR/wDxFIfBkp6+LPEXHpdoP/ZK6aigDmv+EOl/6GvxD/4FR/8AxFH/AAh0v/Q1+If/AAKj/wDiK6WigDmv+EOl/wChr8Q/+BUf/wARR/wh0v8A0NfiH/wKj/8AiK6WigDmv+EOl/6GvxD/AOBUf/xFH/CHS/8AQ1+If/AqP/4iulooA5r/AIQ6X/oa/EP/AIFR/wDxFH/CHS/9DZ4h/wDAqP8A+IrpaKAOa/4Q6X/obPEP/gVH/wDEUf8ACHS/9DZ4h/8AAqP/AOIrpaKAOa/4Q6X/AKGzxD/4FR//ABFH/CHS/wDQ2eIf/AqP/wCIrpaKAOa/4Q6X/oa/EP8A4FR//EUHwbKevivxF/4FJ/8AEV0tF