[go: up one dir, main page]
Scribd
Upload
25 views8 pages

IF Function Practice Tasks2

Uploaded by

ggsilvaboy7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
25 views8 pages

IF Function Practice Tasks2

Uploaded by

ggsilvaboy7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

Name Age Old Enough to Drive?

Paul 16 Not old enough to drive


Jane 27 Old enough to drive
Ian 17 Not old enough to drive
Bob 18 Old enough to drive
Keri 12 Not old enough to drive

Instructions
Write formula into cell C2 which displays the following text:

1) "Old enough to drive" - if the person is aged 17 or older


2) "Not old enough to drive" - if the person is under 17.

Use the autofil drag handle to replicate the formula into cells C3 to C6
ext:

or older
er 17.

cells C3 to C6
Savings Account Amount Saved Savings with bonus
Regular £1,000.00 #VALUE!
Bonus £2,000.00 Bonus
Bonus £500.00 Bonus
Regular £4,000.00 Bonus
Current £10,000.00 Bonus

Instructions
Write formula into cell C2 which performs the following:

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


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

Use the autofil drag handle to replicate the formula into cells C3 to C6
Home Goals Away Goals Result
2 1 Home win
3 5 Away win
2 3 Away win
5 1 Home win

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

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 26

Final Insurance $ 999.75

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 25 or over.

The soloution should adapt to changes made to both age and basic
insurance cost.
Miles Driven Mileage Cost
102 91.8
95 114

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 should be calculated at $0.90 per mile
The soloution should adapt to changes made to the number of miles driven.

You might also like