Excel - If Function
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel - If Function as PDF for free.
More details
- Words: 167
- Pages: 1
IF Functions This function will allow you to evaluate your date and do a calculation based on the result or enter a value dependent on the result. For example in the sheet below we want to enter an IF statement in column xx that returns Yes if the value in column x is higher than the value in column x and No if it is not.
1. 2.
Activate the Formulas ribbon Choose Logical from the Function Library and then select IF The following dialog box will be displayed:
3.
Click on the Logical Test box and type the following: C4>B4 This will analyse the value in cell C4 to see if it is greater than the value in B4
4.
Click in the Value_if_true box and type Yes
5.
Click in the Value_if_false box and type No
6.
Click on OK to complete the formula
Provided by Abacus Computer Training, Rickmansworth T: 01923 710552
PDF Creator - PDF4Free v2.0
M: 07885 232 030
E: [email protected]
http://www.pdf4free.com
1. 2.
Activate the Formulas ribbon Choose Logical from the Function Library and then select IF The following dialog box will be displayed:
3.
Click on the Logical Test box and type the following: C4>B4 This will analyse the value in cell C4 to see if it is greater than the value in B4
4.
Click in the Value_if_true box and type Yes
5.
Click in the Value_if_false box and type No
6.
Click on OK to complete the formula
Provided by Abacus Computer Training, Rickmansworth T: 01923 710552
PDF Creator - PDF4Free v2.0
M: 07885 232 030
E: [email protected]
http://www.pdf4free.com
Related Documents
Excel - If Function
October 2019 12
If(and Function
May 2020 27
Excel Tips Function
November 2019 26
Excel Function Dictionary
May 2020 22
03 Excel If Tunggal
November 2019 13