Scribd
Upload
6 views1 page

Excel If Statement Tutorial

This document provides a tutorial on how to write an If statement in Excel. It shows how to set up a dropdown list in one cell and use an If statement to output different values in another cell depending on the selection in the dropdown list.

Uploaded by

Joey Ding
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views1 page

Excel If Statement Tutorial

This document provides a tutorial on how to write an If statement in Excel. It shows how to set up a dropdown list in one cell and use an If statement to output different values in another cell depending on the selection in the dropdown list.

Uploaded by

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

3.

2 OFFICE 2007

SKILLS TUTORIAL 2

This tutorial will show you how to write an ‘If statement’.

• Open Excel
• Click in cell A2 and set
up a drop down list with
two items in it – Price 1
and Price 2, as shown
here
• Click in cell B2.

• Type the following formula: =IF(A2=“Price 1”,100,50).

This means that if the value in cell A2 is set to Price 1, then the value in cell B2
will be 100.
If the value in A2 is set to Price 2, then the value in cell B2 would be 50.
You can use If statements on any value – it does not have to be from values in a
drop down list.

1 of 2

ICT InteraCT for KS3 2 © Hodder Education 2008

You might also like