Scribd
Upload
18 views1 page

Conditional Formulas in Excel

The document explains how to use conditional formulas in Excel, specifically the IF function. It describes the Function Arguments dialog, which includes three input boxes: Logical_test, Value_if_true, and Value_if_false. These inputs allow users to display different values based on whether a specified condition is met or not.

Uploaded by

chhayayadav17072003
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
18 views1 page

Conditional Formulas in Excel

The document explains how to use conditional formulas in Excel, specifically the IF function. It describes the Function Arguments dialog, which includes three input boxes: Logical_test, Value_if_true, and Value_if_false. These inputs allow users to display different values based on whether a specified condition is met or not.

Uploaded by

chhayayadav17072003
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

Summarize data that meets specific conditions

Summarize data that meets


specific conditions
Another use for formulas is to display messages when certain conditions are met.
This kind of formula is called a conditional formula. One way to create a conditional
formula in Excel is to use the IF function. Selecting the Insert Function button next to
3
the formula bar and then choosing the IF function displays the Function Arguments
dialog with the fields required to create an IF formula.

The Function Arguments dialog for an IF formula

When you work with an IF function, the Function Arguments dialog displays three
input boxes:

■ Logical_test The condition you want to check.


■ Value_if_true The value to display if the condition is met. This could be a cell
reference, or a number or text enclosed in quotes.
■ Value_if_false The value to display if the condition is not met.

83

You might also like