0
Which function returns one value when a condition is met and returns another value when it is not met in Excel?
Wiki User
∙ 11y ago
The IF function. See the related question below.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What function counts the number of cells within a range that meets the given condition?
The COUNTIF function in Excel counts the number of cells that meet a specific criterion within a range. You specify the range and the criteria, and it returns the count of cells that meet that condition.
What is a named operation that returns a value in the Excel program used to simplify formulas?
A function.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
What function in MS Excel which checks the logical condition of a statement?
IF function
Can you use the PMT function in Excel to display dates in many different formats?
The PMT function returns the payment amount for a loan, so it has nothing to do with how dates are displayed. It returns numbers.
What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?
The MATCH function can do that.
What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?
The MATCH function.
What is NPER in Excel?
NPER is a financial function in Excel. It returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Which term describes a function used as an argument for another function?
In Excel a function within another function would be called a nested function.
What does today mean in Excel?
The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.
When assigned to a cell what function returns a number that corresponds to the system date and time?
The function to show current date and time in Excel is =NOW().
What is the difference between the PMT and PPMT functions in Excel?
The PPMT function returns the amt. of interest in a specified instalment number whereas the PMT function returns the amt. of interest in every EMI payment.
