Excel: If-Then-Else formula - application in the utility bill

12-03  Source: Network gathering  Views:5 


Excel: If-Then-Else formula - application in the utility bill

take with the PC operating costs under the microscope

Excel - background knowledge for If-Then-Else formula

The If-Then-Else formula is a formula quite frequently used in Excel spreadsheets. About the detailed definition of various parameters you can specify in what situation your result will turn out like. You can specify both numbers and plain text. Please note that the If-Then-Else formula always begins with an "=" and ends with the last closing parenthesis. If you set text as an output value, this must be set in the If-Then-Else formula in quotation marks. The If-Then-Else formula is made up of three components.

  • The first formula component is the review of a to be determined by you facts. An example would be "= IF (A1> B1)". Although the If-Then-Else formula is still incomplete, are Excel gives you already in this step, a so-called truth value - "true" or "false".
  • As second formula component set the so-called "value_if_true" fixed. Here you determine what you want to appear in Excel, if the contents of cell A1 is actually greater than the cell contents of B1. In this example it is assumed Excel should output the word "credit" if A1> B1. The If-Then-Else formula looks in this step is as follows: "= IF (A1> B1," the bank ")." Your If-Then-Else formula but still not completely.
  • The last formula component is missing the "value_if_false". Again, you specify how the result shown by Excel to fail. Your sample formula could now read "= IF (A1> 25;" credit ";" additional payment ")".
  • After entering the "Dann_Wertes" shows Excel to the preliminary calculation result.

The If-Then-Else formula you can very well use in your utility bill.

The formula in the utility bill

Suppose you create your utility bill with Excel. You automatically want that Excel in cell A27 indicates whether your tenant receives a credit or need to make an additional payment. Imagine this following scenario.

  • In cell D25 is the total sum of the caused by the respective tenants operating costs.
  • The work done by the tenant operating cost prepayments are in cell D26.
  • If the cost of advance payments are lower than those caused operating costs, then your tenant has to make an additional payment. In this case, Excel is in Cell A27 Show "Surcharge".
  • If such prepayments contrast higher than that caused operating costs, should then return in cell A27 "credit" as a result of Excel.
  • Your If-Then-Else formula in cell A27 then to look like this: "= IF (D26> D25;" credit ";" additional payment ")".
  • Now it may happen so that the operating costs and the advance payments are equal. In this case, your formula would also "postpay" show. Since you but in cell D27 in this case the result have are "0,00 Euro", which plays no significant role.
  • Of course, you can nest and specify that Excel in this case in cell A27 "balance" should display your If-Then-Else formula. You would have your formula then adjust as follows: "= IF (D26> D25;" credit "; IF (D26 = D25;" balance ";" additional payment "))"

As you can see, the if-then-else-formula is a very useful Excel function.

Related articles
  • Excel: If-Then-Else formula - application in the utility bill 12-03

    take with the PC operating costs under the microscope Excel - background knowledge for If-Then-Else formula The If-Then-Else formula is a formula quite frequently used in Excel spreadsheets. About the detailed definition of various parameters you can

  • Paste In Excel for paragraph command-formula - how it works 01-10

    generate sales via a command in Excel Excel allows you to quickly and easily perform spreadsheets or create graphics. Using Excel you can perform complex calculations. Thanks to the function wizard You do not notice the individual formulas for the ca

  • Hide In Excel formulas - how it works 02-06

    Formulas in Excel can hide easily. Sandor_Somkuti / Pixelio If you want to protect formulas in an Excel file from prying eyes, you can hide it and make so invisible. First, you must select all cells containing a formula. To highlight in Excel all the

  • Relative field reference in Excel 03-13

    The use of real tive covering can facilitate your work in Excel. Relative Field Reference: Advantages and logical operation Relative field reference provides its greatest benefits when processing similarly formatted and large data. By using cell refe

  • Application - formulate letters personally 04-27

    With the personal letter you make it to the interview. One thing you must consider when personally formulated applications definitely: With personally are always both sides meant. This means that you disclose both personal things about himself than g

  • Excel: add column - manual 08-28

    be carried out with formulas calculations. let whole columns add up in a spreadsheet To calculate data in Excel, you can use formulas for individual cells or entire columns. For this purpose, first the individual cells or columns are marked and then

  • make application for higher grade - how it works 10-18

    A height grouping is done only at the request. Background to the request for higher grade With the introduction of TV-L in November 2006 the complicated BAT tariffs were abolished. This also hardly see through mesh of ascents and allowances. New hire

  • Excel integration: In Word insert an Excel table - how it works 03-16

    integrate an Excel table in Word is actually quite simple. Add Excel tables in Word - Why? Often the question is asked why one should ever integrate Excel into other applications. Power integrating Excel sense? Is not it too cumbersome to integrate E

  • How do I write a good cover letter for my application? 10-27

    With a well-written cover letter your application looks trustworthy. The formal structure of a job candidate mailer The font for your letter, select a font that is easy to read and suits you. As margin be left often 24 mm, and 8 mm right recommended.

  • Excel - a time calculation works like this 11-12

    Thus, for the time in Excel calculate. In Excel, the time calculation formula on the "sum" takes place. Since you have the option of formatting on time formats, this must of course also be used to properly display the results. You can view this

  • Training at Google - Useful information about applying 07-25

    With a skillful application you more employable. Google is a very popular employer Before applying to Google, you should inform yourself about the company. Of course, it is known that Google firstly, the most popular search engine on the Internet, bu

  • Processing of Wedi plates - Tips 01-21

    Wedi plates can be processed easily. You want to renovate your bathroom and are now looking for an alternative for the underground. This must indeed fulfill some claims and the processing of the substrate should be as simple as possible. The claims a

  • How do you make an arrow on the keyboard? 09-21

    Safe working with the keyboard Arrow on the keyboard in Word and Excel How do you make an arrow on the keyboard? This question is probably every user who hardly deals with Word or Excel. Here it's quick and easy. In Word and Excel, you will need it o

  • Calorimeters on the radiator - so you understand the heating bill 01-24

    Heating costs are proportionately agreed to consumption. Can the rental agreement with your landlord that you will have to pay utilities on the lease out, you get every year after the billing period of your landlord's utility billing. This also inclu

  • Hard drive from Hitachi is not recognized by Mac - what to do? 04-26

    use hard disks as storage Hitachi hard drive - also runs on Mac Of course there are a lot of hard drives on the market. Nowadays especially SATA drives offered. So called the Point-to-point connection between the processor and hard drive. Thus especi

  • Charges for heating and hot water - legal information 05-18

    Heating costs are recognized based on usage. Rental contract, the additional costs can be detected varied. The easiest way is to agree on a simple monthly rent (inclusive rent) or a heating costs would be. Then the tenant would pay a lump sum, which

  • Charges for payment - due date, delay, deferral and subsequent claim 11-12

    Charges are timely paid. Normally, you pay in addition to the rent and utilities as a tenant. The landlord must provide you with the rental contract agreed Charges invoiced. These can be arranged individually. Regularly the owner but will refer to th

  • Pension bill lost - what to do? 05-30

    No work without social insurance certificate New application for the pension bill The social security card is often called pension bill. The term is understandable but wrong. The social security card containing the data on the pension, health insuran

  • Basic security in old age and reduced earning capacity 09-07

    Entitlement to basic pension with insufficient retirement incomes Rising housing costs to ensure that more and more people aged must take financial help from the state to complete. Neediness in old age and disability Basic security services are provi

  • Around the surface water to the utilities - how it works 09-30

    Also surface water is one of the utilities. Surface water - you should know If your water bill of surface water is mentioned, it is meant generally the precipitation water that is supplied through your sealed surfaces of the sewer. In most areas, the