Microsoft Office 2016 with Patch for Mac Torrent Full Version Free Download | Computer Software

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvZOvXXceqw4LnzGO9nZ1w46mBsjCBur2dAVeDy4s30EVMUknUHD6PiNgYv2D8lSoUaPYnmpKaWzdpk3Z_jS37v3_tAkgI6S2Jee3KEKNLZOxOSvRc_8UNnprheOLux2p4KGiIcN_hnQLA/s1600/2016.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvZOvXXceqw4LnzGO9nZ1w46mBsjCBur2dAVeDy4s30EVMUknUHD6PiNgYv2D8lSoUaPYnmpKaWzdpk3Z_jS37v3_tAkgI6S2Jee3KEKNLZOxOSvRc_8UNnprheOLux2p4KGiIcN_hnQLA/s200/2016.jpg" width="200" /></a></div><b>Overviews about Microsoft Office 2016 Latest for Mac:</b><br /><br /><i>Welcome to the new Office for Mac!</i><br />Unmistakably Office, designed for Mac. Do your best work—anywhere, anytime and with anyone. Get started quickly with new, modern versions of Word, Excel, PowerPoint, Outlook and OneNote.<br /><b><br /></b>Microsoft Office for Mac 2016 full version free. So the last month the Microsoft has been announced and released Windows 10 all edition and as well as MS Office together of the preliminary version of the office suite Office 2016 for the Mac. So the new Office for Mac is the first major upgrade package Microsoft Office applications on the platform OS X since the release version of Office 2013.<br />Microsoft Office for Mac 2016 v15.13.3 Multi Language with activation CD or Activator full version. This Office suite for your MAC operating system. Now the MAC OSX use can be download and used MS Office 2016 Pro Plus with crack and key. It is very nice and amazing office software that well help you to creating document into word, making balance sheet into ms excel for bank and clark user.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0uw2ThdcnTvdRGELrShSdYTE_A8TW22YcKs0nszANwd7AT-9SLLUddkKY7HSVZj925yrP_SMzs9_7W2qXdtzudIVk-rckWBXmnXijWZ5DIFt9rzwkGn4CpgAjoE3U1UzHuX8_NvKRU51w/s1600/0.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0uw2ThdcnTvdRGELrShSdYTE_A8TW22YcKs0nszANwd7AT-9SLLUddkKY7HSVZj925yrP_SMzs9_7W2qXdtzudIVk-rckWBXmnXijWZ5DIFt9rzwkGn4CpgAjoE3U1UzHuX8_NvKRU51w/s400/0.jpg" width="400" /></a></div><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGwRXT_shBI3QZR1FCWI9iOCWThCcR7CfZSmduL15tGzKJaQ-5pU7A78MaujXKxottHa0E4hi9sxhAGDB886bi0gLf5V_6flebt2OLmDwgnvrTaZVkylqa3QfPGZjEn6a8JOrap1AdywLo/s1600/microsoft-office-2016-for-mac_thumb800.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGwRXT_shBI3QZR1FCWI9iOCWThCcR7CfZSmduL15tGzKJaQ-5pU7A78MaujXKxottHa0E4hi9sxhAGDB886bi0gLf5V_6flebt2OLmDwgnvrTaZVkylqa3QfPGZjEn6a8JOrap1AdywLo/s320/microsoft-office-2016-for-mac_thumb800.jpg" width="320" /></a>Microsoft Publish is a very nice module that will help you to creating a demo of your products with full detail and then you can publish it on the internet. MS Office outlook is a amazing tool that well help you to send and received Email on your PC.<br /><br />Without browsing add images, attach documents and so on and send these to the selected user email id. MS PowerPoint is a another software that well help you to making presentation of different topic for business, collage, school and office used.<br /><br /><b>Word</b><br />Create, polish, and share beautiful and professional documents The state-of-the-art authoring and reviewing tools in Word make the creation of polished documents easy. The new Insights pane shows relevant contextual information from the web inside Word. The Design tab enables you to manage layout, colors, and fonts across a document. Get more done by working together using built-in tools to share and review documents. Several people can work on the same document simultaneously and use threaded comments to have a conversation right next to relevant text.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC5K85wLzBuoRVRTQlFY7942lV-pYrFUc41Vtu7YUTyLJjkjDsdKFrmfMuSwTBIl5r5hLVNBTvVUVYfFfk3_Iv0-p-OAdjplOtTfP8RptahF_8zA9VcjQRs_22XLFMRDLvSnW60LSL5YIk/s1600/Word-Office-365.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC5K85wLzBuoRVRTQlFY7942lV-pYrFUc41Vtu7YUTyLJjkjDsdKFrmfMuSwTBIl5r5hLVNBTvVUVYfFfk3_Iv0-p-OAdjplOtTfP8RptahF_8zA9VcjQRs_22XLFMRDLvSnW60LSL5YIk/s400/Word-Office-365.jpg" width="400" /></a></div><b>Excel</b><br />Analyze and visualize numbers in new and intuitive ways The new Excel for Mac enables you to turn numbers into insights. Familiar keyboard shortcuts and data entry enhancements like formula builder and auto complete immediately make you more productive. Excel also helps you visualize your data by recommending charts best suited for your numbers, and letting you quickly preview the different options. New Pivot Table Slicers help you discover patterns in large volumes of data.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8ZHYNipBfFXDSuoY5nVeY8-nM0xTRlYBBg46LY-G-4_cJ_Uvy_0tyN-jreiMkA971-b71n1laT-dlQkyNvA4CA1veuPIPsPesYB84nldBiz2Y_bAEAi1YlWzUktZoNtOrw8Rt8XUlZepM/s1600/excel-for-mac.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="283" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8ZHYNipBfFXDSuoY5nVeY8-nM0xTRlYBBg46LY-G-4_cJ_Uvy_0tyN-jreiMkA971-b71n1laT-dlQkyNvA4CA1veuPIPsPesYB84nldBiz2Y_bAEAi1YlWzUktZoNtOrw8Rt8XUlZepM/s400/excel-for-mac.png" width="400" /></a></div><b><br /></b><b>PowerPoint </b><br />Create multimedia presentations and present your ideas with confidence Walk into your next presentation with complete confidence. The new Presenter View in PowerPoint displays the current slide, next slide, speaker notes, and a timer on your Mac, while projecting only the presentation to your audience on the big screen. A new Animation pane helps you design and fine-tune animations, and refined slide transitions ensure the finished product is polished. Easily share your presentation and invite others to work on the same presentation simultaneously.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0z-YvSqtaWmssiUjiTxhHGeTasis-qlalRxbtoQpvFoXY-VHd5-KkKr533jT1G0nQGyuQLdoJtbSYfhRgWe7o_v4vvXseDYETvnGs10BOX4TjyMU4YvJluj2M83-K1DPQAYZ21lWsBaR7/s1600/powerpoint-for-mac.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0z-YvSqtaWmssiUjiTxhHGeTasis-qlalRxbtoQpvFoXY-VHd5-KkKr533jT1G0nQGyuQLdoJtbSYfhRgWe7o_v4vvXseDYETvnGs10BOX4TjyMU4YvJluj2M83-K1DPQAYZ21lWsBaR7/s400/powerpoint-for-mac.png" width="400" /></a></div><b>OneNote</b><br />Harness your thoughts in your very own digital notebook Capture, organize, and share your ideas with digital notebooks that you can access on any device. Find things quickly with a powerful search engine that tracks your tags, indexes your typed notes, and recognizes text in images and handwritten notes. Bold, italicize, underline, highlight, insert files, pictures and tables—format your notes like you want. Easily share notebooks with friends, family, or colleagues so everyone can work together on travel plans, household tasks, or work projects.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1OWRZayIHfq2a_1EyU7Yp_OeXed8MrBku5Lby2aTc890dOfDFuV2-WvGxGXm5SsVHkyliFPHKsPO0DBYknMZplJOXMFtYimQCPWSJgSqIWmugMqAe0simoNaHocWf1SKjopMI2OCyjsZk/s1600/OneNote_for_Mac_2016_screenshot.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1OWRZayIHfq2a_1EyU7Yp_OeXed8MrBku5Lby2aTc890dOfDFuV2-WvGxGXm5SsVHkyliFPHKsPO0DBYknMZplJOXMFtYimQCPWSJgSqIWmugMqAe0simoNaHocWf1SKjopMI2OCyjsZk/s400/OneNote_for_Mac_2016_screenshot.png" width="400" /></a></div> <b>Outlook </b><br /><div class="separator" style="clear: both; text-align: center;"></div>Stay organized with an email and calendar experience that's fast and looks great Managing your email, calendar, contacts, and tasks has never been easier. The new Outlook for Mac has push mail support so your inbox is always up to date. The improved conversation view automatically organizes your inbox around threaded conversations, so you'll never hunt for related messages again. And the new message preview gives you the first sentence of an email just below the subject line, so you can quickly decide if you want to read it now or come back later.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU8HTx9JrbIwiDsHdJGstOZFnZDkgwAU6ycOMcuLya6lEzCTdeSHKjN0lqwSNr3Kax0raVvWSdhZPw-urWexwqbRr8Ia88mgNOlmzmB6Jcb6S8_vUjGr2YiQevTHX-KWXew-3o-_BqBQz1/s1600/outlook-2016-759.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgU8HTx9JrbIwiDsHdJGstOZFnZDkgwAU6ycOMcuLya6lEzCTdeSHKjN0lqwSNr3Kax0raVvWSdhZPw-urWexwqbRr8Ia88mgNOlmzmB6Jcb6S8_vUjGr2YiQevTHX-KWXew-3o-_BqBQz1/s400/outlook-2016-759.jpg" width="400" /></a></div><br /><b>Feature of MS Office 2016 for MAC OS latest:</b><br /><ol style="text-align: left;"><li>Easy to use and attractive</li><li>Supported all Mac OS system</li><li>Very light and supported all format of document</li><li>Including Word, Excel, PowerPoint, OneNote and Outlook,</li><li>Supported High Resolution displays and  Retina.</li><li>Open and create PDF, Word, Powerpoint, excel files.</li><li>Very advance convert any document to any other format.</li></ol>More information: <a href="https://products.office.com/en-us/mac/microsoft-office-for-mac" target="_blank">Microsoft Official Site</a>.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKjfNZG1cYBbiSXB0sJ0XHIrM0dNnCYO35wkt9nu5AXJcqEgdWzx3P7IY-Fo1oYx18h42KIRvMS-SZv0QigyPoxbDkDDjM_aCPo0UpZ3vvYZksw8uLhHq9_1j08GqFJx9ytP_vrX0YKExo/s1600/maxresdefault.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKjfNZG1cYBbiSXB0sJ0XHIrM0dNnCYO35wkt9nu5AXJcqEgdWzx3P7IY-Fo1oYx18h42KIRvMS-SZv0QigyPoxbDkDDjM_aCPo0UpZ3vvYZksw8uLhHq9_1j08GqFJx9ytP_vrX0YKExo/s640/maxresdefault.jpg" width="640" /></a></div><br /><b>File Information:</b><br /><ul style="text-align: left;"><li>Name:<span class="Apple-tab-span" style="white-space: pre;"> </span>             Microsoft Office for Mac 2016 15.11.2</li><li>Size:<span class="Apple-tab-span" style="white-space: pre;"> </span>                1.31 GB</li><li>Tracker:<span class="Apple-tab-span" style="white-space: pre;"> </span>           http://109.235.50.166:2710/announce</li><li>Hash:<span class="Apple-tab-span" style="white-space: pre;"> </span>               00c8c3c670d62613d28ad5b6c1f791c79e4706c7</li><li><b>Files: </b><span class="Apple-tab-span" style="white-space: pre;"> </span>             </li></ul><ol style="text-align: left;"><li>Microsoft Office for Mac 2016 v15.11.2/Command_Line_Tools_OS_X_10.10_for_Xcode_6.4.dmg (165.9 MB)</li><li>Microsoft Office for Mac 2016 v15.11.2/Instructions.rtf (0.79 kB)</li><li>Microsoft Office for Mac 2016 v15.11.2/MSO15.11.2Patch.zip (0.85 kB)</li><li>Microsoft Office for Mac 2016 v15.11.2/Microsoft_Office_2016_Installer.pkg.zip (1.15 GB)</li></ol><b>System requirements:</b><br /><ul style="text-align: left;"><li>System Required= Mac computer with an Intel processor</li><li>Operating System= Mac OS X version 10.10</li><li>RAM for System= Recommended 1 GB of RAM</li><li>Hard Disk space free= Just need 6GB GB of free hard disk space</li><li>Note:- Hard disk formatting such as HFS + (also known as Mac OS Extended or HFS Plus)</li><li>LCD, LED Or A monitor with 1280×800 resolution or higher</li><li>Browser= Recommended Safari 7 .</li></ul><b><span style="color: red;">How to install on Mac:</span></b><br /><ol style="text-align: left;"><li>Unzip Microsoft_Office_2016_Installer.pkg.zip</li><li>Install Microsoft_Office_2016_Installer.pkg</li><li>Block connections with Little Snitch or similar software</li><li>Close all Office Apps and chose manually updates</li><li>Install Command Line Tools (Command_Line_Tools_OS_X_10.10_for_Xcode_6.4.dmg)</li><li>Unzip patch 'MSO15.11.2Patch.zip' </li><li>Open the 'terminal.app' (applications/utilities/terminal.app)</li><li>Drag/Drop MSO15.11.2Patch.zip file into terminal and hit enter</li><li>Then Enjoy!</li></ol><b><span style="color: red;">How to download?</span></b><br /><ol style="text-align: left;"><li>It's a torrent file so you have need to first torrent client software, Download Torrent <span style="color: red;"><a href="http://computersoftwares-s.blogspot.com/2016/01/torrent-utorrent-very-tiny-bittorrent.html" target="_blank">click here</a></span>.</li><li>Follow given below method and download <a href="http://computersoftwares-s.blogspot.com/2016/01/torrent-utorrent-very-tiny-bittorrent.html" target="_blank">torrent</a> file</li><li>After complete downloading install office 2016 file.</li></ol>If you like our work please share it with your friends and family on facebook, twitter, or google plus and provide us feedback.<br /><br /><b><span style="color: red;">Note: Some tools, you will have to need download and install  for open Software and Download that software.</span></b><br /><div><div style="text-align: center;"><ol style="text-align: left;"><li>To open this software's file, you will need to WinRAR. If you want to Download WinRAR click <span style="color: red;"><a href="http://computersoftwares-s.blogspot.com/2016/02/winrar-531-32bit-x86-64bit-x64-and-mac.html" target="_blank">here</a></span>.</li><li>Fast Downloading, you will have to need Internet Download Manager (IDM), Click <span style="color: red;"><a href="http://computersoftwares-s.blogspot.com/2016/02/internet-download-manager-idm-625-with.html" target="_blank">here</a></span>.</li><li>Safe and secure download, you must have to download Torrent, click <span style="color: red;"><a href="http://computersoftwares-s.blogspot.com/2016/01/torrent-utorrent-very-tiny-bittorrent.html" target="_blank">here</a></span>.</li></ol><span style="text-align: left;">.----------------------------------------------------------------------------------------------</span><span style="text-align: left;"></span><br /><span style="text-align: left;"></span>Like Us On Facebook For Stay Updated - <a href="http://www.facebook.com/computersoftwares" target="_blank">Page Link</a><br />Follow us On Twitter For Stay Updated - <a href="https://twitter.com/computersoftwre" target="_blank">Link</a><br />----------------------------------------------------------------------------------------------</div><div style="text-align: center;"><div style="text-align: center;"><div style="text-align: left;"><div style="text-align: center;"><div style="text-align: center;"><b>Download Microsoft Office 2016 with Patch for Mac for Mac </b><b>via Torrent</b></div></div></div></div></div><div style="text-align: center;"><br /></div><div style="text-align: center;"><div style="text-align: center;"><span style="text-align: left;">Before download this file, you will need to download Torrent.</span></div><div style="text-align: center;"><span style="text-align: left;">To Download Torrent click</span><span style="text-align: left;"> </span><span style="color: red; text-align: left;"><b><a href="http://computersoftwares-s.blogspot.com/2016/01/torrent-utorrent-very-tiny-bittorrent.html" target="_blank">here</a></b></span><span style="text-align: left;">.</span><br /><span style="text-align: left;"><br /></span><span style="text-align: left;"><b>File Size: 1.31 GB</b></span><br /><span style="text-align: left;"></span></div><div class="separator" style="clear: both;"><a href="magnet:?xt=urn:btih:00c8c3c670d62613d28ad5b6c1f791c79e4706c7&dn=Microsoft%20Office%20for%20Mac%202016%20v15.11.2&tr=http%3A%2F%2F109.235.50.166%3A2710%2Fannounce" target="_blank"><img border="0" height="65" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqFrvrD_CXMLhIcR1X5PmZx1EsxJUDKeLkaYtZ__lLfJTEuSonVjOqSw8BIvvJ4Rhijkk7sf9k4h9Wl9wefBC-poQWhuUsJ70gCB4zJpgLBmwWJ3MuNYWMK_7oK5CDn6Z-1YH_o8SGAjok/s200/Download-Button.png" width="200" /></a></div><br />If you have any problem about it. You can write your problem in Comment Box.</div><div style="text-align: center;"><br /></div><div style="text-align: center;"><b>Computer Software:</b> <i>This site is freeware to Download Software, Games and Mobile applications. You can download free software, Games, Android Apps and Games & many more</i>.</div><div style="text-align: center;"><br /></div><div style="text-align: center;"><b>visit :</b> <a href="http://www.computersoftwares-s.blogspot.com/" target="_blank">www.computersoftwares-s.blogspot.com</a><br /><br /><div style="text-align: center;">----------------------------------------------------------------------------------------------</div><div style="text-align: center;">Like Us On Facebook For Stay Updated - <a href="http://www.facebook.com/computersoftwares" target="_blank">Page Link</a><br />Follow us On Twitter For Stay Updated - <a href="https://twitter.com/computersoftwre" target="_blank">Link</a></div><div style="text-align: center;">----------------------------------------------------------------------------------------------</div></div></div></div>

Diposting oleh Abdullah Syafii

Error Trapping in Excel

I had a query about how to set up a spreadsheet for future rows to be added but without showing all the error messages you get when a formula expects there to be something in a cell which hasn't yet had data entered.<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/TH4gT5-UQQI/AAAAAAAAGDA/5zrhPqp0_5A/s1600/20100901a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5511878520299864322" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/TH4gT5-UQQI/AAAAAAAAGDA/5zrhPqp0_5A/s400/20100901a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 334px;" /></a>Here's an example spreadsheet that works out how many miles per gallon of fuel you are using. I'm old enough to not want to know how many miles per litre I am getting so the spreadsheet converts the litres I buy into gallons.<br /><br />I have entered data up to row 8 but from row 9 downwards there are either errors or data showing where I don't want to see anything until data is entered into those rows.<br /><br />The only data I need to enter will go in column A (the date I buy fuel), column B (the mileage shown on the odometer of my car when I refuel) and column D (the number of litres I put in the tank).<br /><br />A formula in cell C9 <strong>=B9-B8 </strong>calculates how many miles since the last refuelling. Because there is no data in cell B9 it has calculated a value of -4328 ie zero minus the value in cell B8.<br /><br /><a href="http://3.bp.blogspot.com/_i9xWjDR4D-E/TH4jTMFKW1I/AAAAAAAAGDI/1RwsJs80DX0/s1600/20100901b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5511881806515428178" src="http://3.bp.blogspot.com/_i9xWjDR4D-E/TH4jTMFKW1I/AAAAAAAAGDI/1RwsJs80DX0/s400/20100901b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 334px;" /></a>The display in cell E9 is even worse because there is an error message displayed due to the lack of data in cell D9 which is causing a <em>Divide by Zero </em>error.<br /><br />The formula in cell D9 is <strong>=C9/(D9/4.546)</strong>. The bit inside the brackets (<strong>D9/4.546</strong>) converts the number of litres into gallons. Then the number of miles travelled, held in cell C9, is divided by the number of gallons to give the miles per gallon figure.<br /><br />There really is no error here in human terms because the data simply hasn't been entered yet. But unless we want to copy the formulae down every time we add a row of data, the spreadsheet will see a logical error and report it.<br /><br />So we can use a simple <strong>=IF </strong>formula to test for the existence of a value in the critical cells before displaying anything.<br /><br /><a href="http://2.bp.blogspot.com/_i9xWjDR4D-E/TH4o8C8RjsI/AAAAAAAAGDo/KSG-3S1rh1c/s1600/20100901c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5511888005995007682" src="http://2.bp.blogspot.com/_i9xWjDR4D-E/TH4o8C8RjsI/AAAAAAAAGDo/KSG-3S1rh1c/s400/20100901c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 334px;" /></a>In cell C9 we have the formula <strong>=IF(B9="","",B9-B8)</strong>.<br /><br />Let's break down the <strong>=IF </strong>syntax first then look at what it is doing.<br /><br />It uses the commas to separate the different segments and takes the form <strong>=IF(you find this, then do this, otherwise do this)</strong><br /><br />If a cell contains nothing, that can be represented by placing the contents (nothing) between a set of double quote marks - "". Note that there is a big difference between nothing and a zero! So we can't use <strong>=IF(B9=0</strong>...<br /><br />So the formula is saying; <strong>=IF(B9 holds nothing, do nothing, otherwise display B9-B8)</strong><br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/TH4m4FhUGkI/AAAAAAAAGDY/tpL7kygfK4s/s1600/20100901d.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5511885738944502338" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/TH4m4FhUGkI/AAAAAAAAGDY/tpL7kygfK4s/s400/20100901d.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 334px;" /></a>Likewise we can add a similar <strong>=IF </strong>to the formula in cell E9, in which case the existence of a value in cell D9 are the key to whether we want a value displayed or not.<br /><br /><strong>=IF(D9="","",C9/(D9/4.546))</strong><br /><br />The formulae can be copied down both columns B and E and each time you refuel you just need to add data to columns A, B and D to complete the row.

Diposting oleh Abdullah Syafii

Excel: Manipulating text with LEFT, RIGHT, LEN, FIND, IFERROR

This entry solves the problem of having a single field for someone's name in a spreadsheet but then wanting to split it into forename and surname - perhaps because you want to sort rows alphabetically by name - hmm... yes... there's another entry to come!<br /><br />This one was suggested by a colleague, <em>Patrick Bellis</em> and he did actually provide a solution as well. I've had a fiddle and come up with an enhanced version though that shows how to deal with entries that have two forenames or a middle name or initial. It doesn't deal with more than one middle name or initial although you can do that easily - details later!<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SmbkrfRzgDI/AAAAAAAAE4o/G3d1q5EEQNE/s1600-h/20090722a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5361223842212839474" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SmbkrfRzgDI/AAAAAAAAE4o/G3d1q5EEQNE/s400/20090722a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 228px;" /></a>So in my simple example, the <em>Full Name</em> field was the previously existing field and I have used formulae to split this into the two new fields, <em>Forename</em> and <em>Surname</em>.<br /><br />Now I have to say that this isn't my preferred way of doing this. My preferred way would be to use a <em>Visual Basic</em> (or <em>VB</em>) routine in a macro, but whilst these work for me quite easily in MS Access - the database application that comes with Microsoft Office Professional, I've never managed to get VB macros to work in Excel even when my efforts look exactly like the example in the <em>Help</em> pages. Someone else will have to suggest a fix for that perhaps?<br /><br />The <em>VB</em> routine would allow me to search for the <em>last</em> space within the name field. Using a simple formula, we have to search for the <em>first</em> space and that's why there's a problem with people who have middle names.<br /><br />To get over this partly - more specifically to deal with people who have a single middle name or initial - I've used a third new column which I've placed over to the right, out of the way where it doesn't need to be seen or printed. It's doing nothing other than an interim calculation or manipulation of the <em>Full Name</em> field.<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/Smblu2MAnRI/AAAAAAAAE4w/SeKFO6sZFQ4/s1600-h/20090722b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5361224999413783826" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/Smblu2MAnRI/AAAAAAAAE4w/SeKFO6sZFQ4/s400/20090722b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 224px;" /></a>I've left a blank column between the working bits of the spreadsheet and this interim field but in reality you may want to hide it away far over to the right - say in column Z or even ZZ!<br /><br />This interim field searches for the first space and will contain all the text that comes <em>after</em> that first space. <br /><br />But before we look at the formula for that field let's deal with the simplest formula - that for the <em>Forename</em> field. Before we even do that let's look at the common syntax (the use of characters and the order they must be used) that formulas in Excel have. <br /><br />Any formula starts with an equals sign (=). This tells Excel that we want it to calculate something rather than treat the following characters as a string of text.<br /><br />Many formulas use brackets (or <em>parentheses</em> to give them their posh name) to contain any parameters the formula needs to work and use commas (,) to separate each parameter. The formula name tells Excel what to do and the parameters tell it what to do it <em>to</em> and <em>how</em>. A bit like:<br /><br /><strong>=DO-THIS(Do it to <em>this</em>, Do it <em>like</em> this)</strong><br /><br />Formulas can be <em>nested</em>. That means we can use one formula to calculate the parameters for another formula. To find the <em>Forename</em> from the <em>Full Name</em> we need a formula that does this:<br /><br /><strong>RETURN THE CHARACTERS(from the <em>Full Name</em>, until you reach a space)</strong><br /><br /><br />For the Forename in Row 3 (so in the cell C3) the formula is:<br /><br /><strong>=IFERROR(LEFT(A3,FIND(" ",A3,1)),"")</strong><br /><br />There are three different functions here and as with all mathematical formulae you should start by understanding the innermost set of brackets first.<br /><br />That set contains the parameters for the <em>FIND</em> keyword. The <em>FIND</em> formula counts the character that contains the first character of the string we want to find (the example will make this clear). The syntax for <em>FIND</em> is:<br /><br /><strong>FIND(the string of text you want to find, the string of text you want to find it <em>within</em>, the first character within the original string that you want to start searching from)</strong><br /><br />Whoa! Too Much! Don't panic yet - I'm about to explain step by step. <br /><br />Step 1. The string of text we want to find is a space. So in the actual formula a few lines up you see <em>...FIND(" "...</em><br /><br />Step 2. The string of text we want to find the space within, is the <em>Full Name</em> field. So instead of actual text we have a pointer to cell A3. So far we have explained <em>...FIND(" ",A3...</em><br /><br />Step 3. I've put a figure one - <em>1</em> - because I want to start searching from the first character. Now; you could argue that there shouldn't be a space until at least the second character so I should have used a 2. But whilst there <em>shouldn't</em> that doesn't mean there <em>won't</em> be a space as the first character. Someone might have wanted to put their first initial and then their surname but not pressed the initial key hard enough. So by using a 1 instead of a 2, we do a simple bit of error trapping.<br /><br />So that should explain <em>...FIND(" ",A3,1)...</em> The result of that bit of the formula is the number of the character that contains the space as counted from the left. So as cell A3 contains the text "<em>John Burke</em>" the FIND formula should find the space in character 5 and that is the "result" or "return" of the FIND formula. In the next cell down when considering the string "<em>Seamus O'Leary</em>", the space is the 7th character so the FIND formula returns 7.<br /><br />Thus as we consider the next most inner bit of the formula - which is the LEFT keyword - I can simplify the formula for you.<br /><br />Instead of considering:<br /><br /><strong>LEFT(A3,FIND(" ",A3,1))</strong><br /><br />we can consider it as:<br /><br /><strong>LEFT(A3,5)</strong><br /><br />because Excel calculates the innermost formula first and works outwards, so once the <em>FIND</em> formula has run the <em>LEFT</em> formula works using the result.<br /><br />The <em>LEFT</em> formula chops and returns the text from the start (left) of the target string depending on how many characters you want. The syntax for <em>LEFT</em> is:<br /><br /><strong>LEFT(a string of text, the number of characters starting at the left of the string that we want to use)</strong><br /><br />Again the string of text we want to use is contained in cell A3 so we have <em>LEFT(A3...</em> and the number of characters we want to use (as calculated by the <em>FIND</em> formula) is 5. So <em>LEFT(A3,5)</em> is the same as <em>LEFT("John Burke",5)</em> and the result is <em>"John "</em>. Note that there is a space at the end, because we asked for 5 characters. It won't show so it doesn't matter, but if you wanted to be pedantic (anyone having problems with the formula should ignore this as over complicated) we could have used <em>LEFT(A3,FIND(" ",A3,1)-1)</em> which would have subtracted 1 from the value returned by the <em>FIND</em>.<br /><br />Ahem! But that's just being a clever clogs!<br /><br />So that just leaves us with the <em>IFERROR</em> bit of the formula and what that does is it stops Excel from coming up with an error message if there is no space at all.<br /><br />Basically the syntax for <em>IFERROR</em> is:<br /><br /><strong>IFERROR(I want Excel to do this, but if it finds an error then do this instead)</strong><br /><br />In the last parameter I've used two double quote marks "" - or in other words I've told Excel that if there is an error, instead of reporting that there's been an error it can show the text within the quote marks. Which is nothing. No text at all. The cell would be empty. Excel isn't good at telling you what's wrong; it just tells you there has been an error.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/Smb3qhqi_SI/AAAAAAAAE44/nqQ-Ewbv7u8/s1600-h/20090722c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5361244716394544418" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/Smb3qhqi_SI/AAAAAAAAE44/nqQ-Ewbv7u8/s400/20090722c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 217px;" /></a>Without the <em>IFERROR</em> formula if there is no space at all then you just get the dreaded <em>#VALUE!</em> error, which tells you absolutely nothing! See Row 7 in the screen grab.<br /><br />And so to the surname... Unfortunately there is no way of saying 'Now take the rest' after having done a <em>LEFT</em> formula. But there is a <em>RIGHT</em> formula which does the same as the <em>LEFT</em> only from the rear of the text string.<br /><br /><strong>RIGHT(a string of text, the number of characters starting at the right of the string that we want to use)</strong><br /><br />Our problem now is that just because we know the position of the space, that still doesn't tell us how many characters we want from the right hand end of the Full Name, because we don't know how many characters there are in the surname.<br /><br />So we need to know how long the entire string of text is and to do that we use the <em>LEN</em> formula:<br /><br /><strong>LEN(a string of text)</strong><br /><br />The <em>LEN</em> formula only needs a single parameter and returns a number which is the number of characters contained within the string.<br /><br /><em>LEN("Fred Bloggs")</em> would return 11. (it's counting the space as a character don't forget)<br /><br /><em>LEN(A3)</em> returns 10 - because cell A3 contains the text "<em>John Burke</em>"<br /><br />What we need for the <em>Surname</em> is the length of the <em>Full Name </em>minus the length of the <em>Forename</em>.<br /><br />So including our error trap use of IFERROR in case there is no space character, our formula is:<br /><br /><strong>=IFERROR(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),A3)</strong><br /><br />Break it down from the innermost formula(s) in the nest. That's <em>LEN</em> and <em>FIND</em>. Both return numbers and we are taking <em>LEN</em> formula and then subtracting the result of the <em>FIND</em> formula. That gives us the number of characters to be returned by the <em>RIGHT</em> formula and as long as there is a space existing in cell A3 then we have our final result.<br /><br />The <em>IFERROR</em> formula this time, instead of returning no text at all, returns all of the <em>Full Name </em>field - assuming that any text with no spaces will be a surname. You can change this round if you keep a spreadsheet of celeb names such as <em>Madonna</em> or <em>Prince</em>!<br /><br /><strong>IFERROR(the main formula,A3)</strong><br /><br />Now I just need to explain the interim field. The nested formula for the Surname as described above would take everything from the <em>first</em> space. So if there is a middle name or initial then you get that <em>plus</em> the Surname. I've created an interim field with the formula just described and then the Surname field has a formula that is exactly the same but which <em>takes its original text string from the interim field</em> instead of the <em>Full Na</em>me field.<br /><br />You could have as many interim fields as you want, each whittling a middle name or initial out of the final surname, and with no errors even if there is no middle name.<br /><br />12 such interim columns would let you deal with those unfortunate people whose father named them after the long-forgotten football team in the 1960s or 1970s!

Diposting oleh Abdullah Syafii

Excel: Merge Cells and Multiple Lines in Cells

A couple of related formatting tricks that you can use within a spreadsheet this time.<br /><br />Let's start with a look at a standard bit of data.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SlMpovAdyvI/AAAAAAAAE1g/vQq2CAOq50Q/s1600-h/20090707a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355670161663576818" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SlMpovAdyvI/AAAAAAAAE1g/vQq2CAOq50Q/s400/20090707a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 231px;" /></a>Column A holds the collective heading - the people in Column B in the first four rows belong to Team A and then Team B personnel are held in rows 5 to 8.<br /><br />We could just repeat the descriptive header by selecting cell A1 and copying it down to the next three rows. But it then starts to become less clear because there is too much confusing text.<br /><br />So instead we'll merge cells A1 to A4 together as a single cell. In Excel a range of cells is written using the syntax A1:A4 - the colon means "<em>through to</em>".<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SlMqnR32oCI/AAAAAAAAE1o/-45tQRRR_us/s1600-h/20090707b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355671236174585890" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SlMqnR32oCI/AAAAAAAAE1o/-45tQRRR_us/s400/20090707b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 255px;" /></a>So we need to select the four cells by clicking into A1 and then <a href="http://computerbasicsforfree.blogspot.com/2008/11/click-and-drag.html">click and dragging</a> until the range A1:A4 is selected.<br /><br />Then we select the <em>Merge & Center</em> whilst tutting slightly at the American spelling and hey presto, the four cells become one whilst at the same time the text has been centred in the horizontal plane. The text though has moved to the bottom of the new cell, to the spot previously occupied by cell A4.<br /><br />This is because <em>Merge and Center</em> (tut!) is more often used to merge cells next to each other horizontally - grouping a number of column headings for instance.<br /><br />We can do a couple of things now to format that and they include centring (darn it - the American spelling would look better there...) the text vertically and twizzing it round (Lancashire/technical term for aligning it vertically).<br /><br /><a href="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMtSR8cW8I/AAAAAAAAE1w/FHGYrVxFtls/s1600-h/20090707c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355674173951466434" src="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMtSR8cW8I/AAAAAAAAE1w/FHGYrVxFtls/s400/20090707c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 313px;" /></a>Select cell A1 (the merged cell still has that designation) and <a href="http://computerbasicsforfree.blogspot.com/2008/11/just-right-click.html">right-click</a> the mouse to bring up the dialogue box shown.<br /><br />Now select <em>Format Cells</em>.<br /><br /><a href="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMuPhrHqOI/AAAAAAAAE14/mOE_SsjrXqs/s1600-h/20090707d.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355675226145794274" src="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMuPhrHqOI/AAAAAAAAE14/mOE_SsjrXqs/s400/20090707d.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 287px;" /></a>The resulting dialogue window allows us to format lots of things but for now we are interested in the Alignment tab (pointy hand 1).<br /><br />We can alter the text alignment to centre the text both horizontally and vertically (pointy hand 2) and we can twiz (or is it twizz?) the text (pointy hand 3).<br /><br />Having clicked the <em>Ok</em> button and resized the cell by double-clicking the right cell wall to get the <em>best fit</em> the result is as shown below. <br /><br /><a href="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMxMEZR48I/AAAAAAAAE2I/BmlQJ8uAp3M/s1600-h/20090707e.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355678465281614786" src="http://3.bp.blogspot.com/_i9xWjDR4D-E/SlMxMEZR48I/AAAAAAAAE2I/BmlQJ8uAp3M/s400/20090707e.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 314px;" /></a>The pointy hand shows the simple way of aligning text left, right or centred in both horiziontal and vertical planes. The <em>AB</em> button with the little arrow to the right of the pointy hand can be used to twiz text - it opens the same dialogue box we have just used.<br /><br />That's one way of doing it. Here's the other - which may appear simpler, but may not meet your needs. It's always good to have an alternative!<br /><br />If whilst typing the names of the team members we used the ALT-Enter key combination we can force cell B1 to accept multiple lines within the single cell.<br /><br />So we type <em>John Tharmy</em> then hold down the <em>ALT</em> key and whilst it's held down, tap the <em>Enter</em> key. Now without moving from the cell type <em>Sally Vaite</em> and use ALT-Enter again until we read the last name. Now tap the <em>Enter</em> alone as you would normally do and the list of names each occupy a line within the single cell.<br /><br /><a href="http://2.bp.blogspot.com/_i9xWjDR4D-E/SlMw8Hv8ThI/AAAAAAAAE2A/6QICIljwGT4/s1600-h/20090707f.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5355678191304068626" src="http://2.bp.blogspot.com/_i9xWjDR4D-E/SlMw8Hv8ThI/AAAAAAAAE2A/6QICIljwGT4/s400/20090707f.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 249px;" /></a>Job done!

Diposting oleh Abdullah Syafii

Excel: Keep Headings in View Whilst Scrolling

A question I've been asked a few times is how to keep headings in view when you scroll down or across a large spreadsheet.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtWUF4T08I/AAAAAAAAEt8/PGuFYZ3YIAQ/s1600-h/20090619a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348963885608326082" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtWUF4T08I/AAAAAAAAEt8/PGuFYZ3YIAQ/s400/20090619a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Here I've got a spreadsheet that records the number of views my photos get daily at my <a href="http://www.flickr.com/photos/bispham2/">Flickr account</a>. Every day I look at the stats on my account and in the spreadsheet I enter the number of views per day and the number of photographs I have stored there. From these two pieces of information the spreadsheet can work out the total number of views by adding the total from the previous day to the daily number of views and the average views per photo by dividing the total views by the number of photos.<br /><br />However over the course of a year or two there are so many entries (days) that the column headings would normally disappear off the top of the screen when you scroll down.<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/SjtXlevVcXI/AAAAAAAAEuE/znGhpeXcGIg/s1600-h/20090619b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348965283850973554" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/SjtXlevVcXI/AAAAAAAAEuE/znGhpeXcGIg/s400/20090619b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>To stop this happening I've used the <em>Freeze Panes</em> function of Excel to stop the top two rows from scrolling. Those two rows contain the headings and remain on screen whilst the rest of the rows scroll.<br /><br />To start, select the cell underneath and to the right of the rows and columns you want to keep in view. In my example I only want to freeze the top two rows, not any columns at the left, so the cell I've selected is A3.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYaVyCBrI/AAAAAAAAEuM/V3x7Q0iok2c/s1600-h/20090619c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348966191979431602" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYaVyCBrI/AAAAAAAAEuM/V3x7Q0iok2c/s400/20090619c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Then I select the <em>View</em> tab from the menus at the top.<br /><br /><a href="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYruk1jII/AAAAAAAAEuU/5PmDXltGF6A/s1600-h/20090619d.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5348966490692750466" src="http://1.bp.blogspot.com/_i9xWjDR4D-E/SjtYruk1jII/AAAAAAAAEuU/5PmDXltGF6A/s400/20090619d.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 251px;" /></a>Finally I select one of the options from the <em>Freeze Panes</em> icon.<br /><br />Note that once you have frozen some headings, the options change to include an <em>Unfreeze</em> option.<br /><br />Now I can scroll down as far as I need to and can still see the column headings.

Diposting oleh Abdullah Syafii

Excel - Counting Occurrence of Text Values

Here's a poser I was asked today. Someone had an existing spreadsheet that had a column containing text, but she wanted a count of the occurrence of certain values.<br /><br />Let's look at a simple example of what she wanted.<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/SYBotwpmFnI/AAAAAAAAD_k/vkg0aXO9mt0/s1600-h/20090128a.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5296348297150469746" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/SYBotwpmFnI/AAAAAAAAD_k/vkg0aXO9mt0/s400/20090128a.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 253px;" /></a>A summary of how many fields contain "red", how many "blue" and how many "yellow" is required. Now I'm going to keep this simple but if it was possible to enter either "red" or "RED" or "Red" or, worse, "scarlet" then the solution would be a bit more complicated, though still possible - perhaps a future entry to come!<br /><br />Here though the users have been told to use just the standard term, using lower case throughout. So the field only contains one of three possible values with a fourth value perhaps being an empty field.<br /><br />Here's a simple solution. There are other solutions more complicated but more elegant in that they don't require the use of any extra cells in the spreadsheet. Again perhaps a future entry will look at these (there's more than one way to skin this particular cat as there are in most forms of computing!)<br /><br /><a href="http://3.bp.blogspot.com/_i9xWjDR4D-E/SYBpk5qtyeI/AAAAAAAAD_s/qDvUMzJJsNw/s1600-h/20090128b.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5296349244463892962" src="http://3.bp.blogspot.com/_i9xWjDR4D-E/SYBpk5qtyeI/AAAAAAAAD_s/qDvUMzJJsNw/s400/20090128b.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 253px;" /></a>I've used the next three columns to calculate a numerical value registering the instances of each colour - a column being required for each of the three colours. In other words, I've not entered all those zeros and ones, the spreadsheet has used a formula to determine what value should be in each cell.<br /><br />The solution uses the <em>if</em> statement which follows this syntax form<br /><br /><strong>=if(argument being tested, value if true, value if false)</strong> <br /><br />The equals sign ( = ) is necessary before the <em>if</em> so that Excel recognises that what follows is a formula and not a piece of text.<br /><br />The argument being tested here is <em> does the value of cell A2 equal the text within the quotes - ie</em> red<em>?</em><br /><br />It does so the argument is true, therefore the <em>value if true</em> part of the formula is used which in this case is a numerical 1. Note that if we had wanted a text value we could have used quotes and text messagea as the <em>value if true</em> and <em>value if false</em> <br /><br />e.g.: <strong>=if(A2="red","A red lover!", "What's wrong with red?")</strong><br /><br />I needed to type in the formula for the first row only. After that I selected those three cells and used the <a href="http://computerbasicsforfree.blogspot.com/2008/11/click-and-drag.html">click and drag</a> technique to copy them down the columns. Excel is clever enough to know that if you copy in this way it will amend the formula for each row to calculate from <em>that</em> row - instead of every row calculating using the value in the first row.<br /><br />All we need to do now is add up each column for our summary. We could put a count at the bottom of each column and then use that or we could use the <em>sum</em> formula like this:<br /><br /><a href="http://4.bp.blogspot.com/_i9xWjDR4D-E/SYBtRB-F9WI/AAAAAAAAD_0/aCgiYV1bsd4/s1600-h/20090128c.jpg"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5296353301141779810" src="http://4.bp.blogspot.com/_i9xWjDR4D-E/SYBtRB-F9WI/AAAAAAAAD_0/aCgiYV1bsd4/s400/20090128c.jpg" style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 379px;" /></a>And the job's a good 'un!

Diposting oleh Abdullah Syafii