Posts

Calculate Disscount in Excel using Netsted If Formulas in Excel 2016 with Sujeet Kumar

Image
Calculate Disscount in Excel using Netsted If Formulas in Excel 2016 with Sujeet Kumar How to use Excel IF function with multiple conditions In summary, there can be 2 basic types of multiple conditions - with AND and OR logic. Consequently, your IF function should embed an AND or OR function in the logical test, respectively. AND function . If your logical test contains the AND function, Microsoft Excel returns TRUE if  all the conditions  are met; otherwise it returns FALSE. OR function . In case you use the OR function in the logical test, Excel returns TRUE if  any of the conditions  is met; FALSE otherwise. To better illustrate the point, let's have a look at a few IF examples with multiple conditions. Example 1. Using IF & AND function in Excel Suppose, you have a table with the results of two exam scores. The first score, stored in column C, must be equal to or greater than 20. The second score, listed in column D, must be equal to or exceed 30. O
Image
Send Email via Excel VBA to Outlook - Excel VBA Macros Training In Hindi   Mail the whole workbook Important read this : The code on this page is only working when you use Outlook as your mail program. Copy the code in a Standard module of your workbook, if you just started with VBA see this page. Where do I paste the code that I find on the internet Check out this Tip page for changing the code on this page. Tips for changing the code examples Example 1 The following subroutine sends the last saved version of the active workbook in an e-mail message. Change the mail address and subject in the macro before you run it. Sub Mail_workbook_Outlook_1() 'Working in Excel 2000-2016 'This example send the last saved version of the Activeworkbook 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.C