Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Nested If Function Practice Tasks

    Uploaded by

    Subscribe right now
    Here is the formula to calculate the soil cost based on the pH in cell H7 and replicated down column H: =IF(E7="Acid",C2*G7,IF(E7="Alkaline",C3*G7,IF(E7="Neutral",C4*G7))) This IF function checks the pH in column E. If it is Acid, it multiplies the acid rate in C2 by the bare root price in G7. If the pH is Alkaline, it multiplies the alkaline rate in C3 by the bare root price. If the pH is Neutral, it multiplies the neutral rate in C4 by the bare root price. This

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Nested If Function Practice Tasks

    Uploaded by

    Subscribe right now
    13 views8 pages
    Here is the formula to calculate the soil cost based on the pH in cell H7 and replicated down column H: =IF(E7="Acid",C2*G7,IF(E7="Alkaline",C3*G7,IF(E7="Neutral",C4*G7))) This IF function checks the pH in column E. If it is Acid, it multiplies the acid rate in C2 by the bare root price in G7. If the pH is Alkaline, it multiplies the alkaline rate in C3 by the bare root price. If the pH is Neutral, it multiplies the neutral rate in C4 by the bare root price. This

    Original Title

    Nested if Function Practice Tasks

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Here is the formula to calculate the soil cost based on the pH in cell H7 and replicated down column H: =IF(E7="Acid",C2*G7,IF(E7="Alkaline",C3*G7,IF(E7="Neutral",C4*G7))) This IF function checks the pH in column E. If it is Acid, it multiplies the acid rate in C2 by the bare root price in G7. If the pH is Alkaline, it multiplies the alkaline rate in C3 by the bare root price. If the pH is Neutral, it multiplies the neutral rate in C4 by the bare root price. This

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views8 pages

    Nested If Function Practice Tasks

    Uploaded by

    Subscribe right now
    Here is the formula to calculate the soil cost based on the pH in cell H7 and replicated down column H: =IF(E7="Acid",C2*G7,IF(E7="Alkaline",C3*G7,IF(E7="Neutral",C4*G7))) This IF function checks the pH in column E. If it is Acid, it multiplies the acid rate in C2 by the bare root price in G7. If the pH is Alkaline, it multiplies the alkaline rate in C3 by the bare root price. If the pH is Neutral, it multiplies the neutral rate in C4 by the bare root price. This

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 8

    Savings Account Amount Saved Savings with bonus

    Super Bonus £1,000.00 £3,000.00


    Bonus £2,000.00 £4,000.00
    Bonus £500.00 £1,000.00
    Regular £4,000.00
    Current £10,000.00

    Instructions
    Write formula into cell C2 which performs the following:

    1) Double the amount saved if the savings account is "Bonus"


    2) Tebles the amount saved if the savings account is "Super Bonus"
    3) Adds no bonus to the amount saved if the savings account is not "Bonus" or "Super Bonus".

    Use the autofil drag handle to replicate the formula into cells C3 to C6
    or "Super Bonus".
    Home Goals Away Goals Result
    2 1 Home win
    3 5 Awaywin
    2 3 Awaywin
    1 1 Draw

    Instructions
    Write formula into cell C2 which performs the following:

    1) Displays the text "Home win" if the home team scores more goals than the away team
    2) Displays the text "Away win" if the away team scores more goals than the home team
    3) Displays the text "Draw" if both teams score equal amount of goals

    Use the autofil drag handle to replicate the formula into cells C3 to C5
    he away team
    e home team
    Basic Insurance $ 1,000.00 25%

    Age 25

    Final Insurance $1,000

    Instructions

    We need to add an IF Function to cell B5 that:

    increases the insurance quote by 25% if the driver is under 25


    decreases it by 25% if the driver is over 25.
    Makes no change to the basic insurance quote if the driver is exactly 25

    The soloution should adapt to changes made to both age and basic insurance cost.
    Miles Driven Mileage Cost
    151 $0.50

    Instructions

    We need to add an IF Function to cell B1 that calculates milage costs using the
    following rules:

    First 100 miles driven should be calculated at $1.20 per mile


    Any miles driven after 100 and up to 150 should be calculated at $1 per mile
    Any miles after 150 should be calculated at $0.50 per mile

    The soloution should adapt to changes made to the number of miles driven.
    PH Species Weighting Psize Rate
    Acid 6 1.27 2 0.12
    Alkaline 23 0.928 3 0.4
    Neutral 7 1 4 0.795

    Code Species MaxSize PH Size Bare Pot Soil Cost


    Al Alder 2 Alkaline 2 £0.73 £0.12 £0.68 £0.80
    Al Alder 2 Alkaline 3 £0.95 £0.40 £0.88 £1.28
    Al Alder 2 Alkaline 4 £1.09 £0.80 £1.01 £1.81
    As Ash 3 Alkaline 3 £0.95 £0.40 £0.88 £1.28
    As Ash 3 Alkaline 4 £1.09 £0.80 £1.01 £1.81
    Be Beech 3 Alkaline 2 £0.77 £0.12 £0.71 £0.83
    Be Beech 3 Alkaline 3 £1.20 £0.40 £1.11 £1.51
    Be Beech 3 Alkaline 4 £1.57 £0.80 £1.46 £2.25
    SB Silver Birch 3 Acid 2 £0.79 £0.12 £1.00 £1.12
    SB Silver Birch 3 Acid 3 £1.00 £0.40 £1.27 £1.67
    SB Silver Birch 3 Acid 4 £1.10 £0.80 £1.40 £2.19
    SC Sweet Chestnut 3 Acid 2 £0.80 £0.12 £1.02 £1.14
    SC Sweet Chestnut 3 Acid 3 £1.00 £0.40 £1.27 £1.67
    SC Sweet Chestnut 3 Acid 4 £1.45 £0.80 £1.84 £2.64
    HC Horse Chestnut 3 Alkaline 2 £0.78 £0.12 £0.72 £0.84
    HC Horse Chestnut 3 Alkaline 3 £1.08 £0.40 £1.00 £1.40
    HC Horse Chestnut 3 Alkaline 4 £1.21 £0.80 £1.12 £1.92
    Li Lime 3 Alkaline 2 £0.87 £0.12 £0.81 £0.93
    Li Lime 3 Alkaline 3 £1.08 £0.40 £1.00 £1.40
    Li Lime 3 Alkaline 4 £1.44 £0.80 £1.34 £2.13
    Wa Walnut 1 Neutral 3 £2.53 £0.40 £2.53 £2.93
    FM Field Maple 2 Alkaline 2 £0.75 £0.12 £0.70 £0.82
    FM Field Maple 2 Alkaline 3 £0.95 £0.40 £0.88 £1.28
    FM Field Maple 2 Alkaline 4 £1.10 £0.80 £1.02 £1.82
    Oa Oak 3 Alkaline 2 £0.80 £0.12 £0.74 £0.86
    Oa Oak 3 Alkaline 3 £1.12 £0.40 £1.04 £1.44
    Sy Sycamore 2 Neutral 2 £0.73 £0.12 £0.73 £0.85
    Sy Sycamore 2 Neutral 3 £0.82 £0.40 £0.82 £1.22
    Sy Sycamore 2 Neutral 4 £0.96 £0.80 £0.96 £1.76
    Wi Willow 2 Neutral 2 £0.87 £0.12 £0.87 £0.99
    Wi Willow 2 Neutral 3 £0.96 £0.40 £0.96 £1.36
    Wi Willow 2 Neutral 4 £1.02 £0.80 £1.02 £1.82
    Ye Yew 2 Alkaline 2 £3.85 £0.12 £3.57 £3.69
    Ye Yew 2 Alkaline 3 £4.76 £0.40 £4.42 £4.82
    Pp Poplar 3 Alkaline 3 £1.09 £0.40 £1.01 £1.41
    Pp Poplar 3 Alkaline 4 £1.25 £0.80 £1.16 £1.96
    Instructions

    In cell H7 use an IF Function to calculate the cost of the soil used to plant
    different types of trees:

    If the PH is Acid then multiply the named cell acid (C2) by the Bare root price.
    If the PH is Alkaline then multiply the named cell alkaline (C3) by the Bare root
    price.
    If the PH is Neutral then multiply the named cell neutral (C4) by the Bare root
    price.

    Replicate this formula so that the soil price for each tree is shown.

    You might also like