Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Lookup

LOOKUP

  • May 31, 2023
Definition: LOOKUP is a function that searches for a value in a range of cells and returns a corresponding value from the same position in another range of...
Read More

EQUIV

  • May 31, 2023
Definition: EQUIV is a function that returns the annual interest rate for an investment that pays interest at different intervals. Syntax: =EQUIV(nominal_rate, npery1, npery2) Situation: This formula is...
Read More

DGET

  • May 31, 2023
Definition: DGET is a function that extracts a single value from a database that meets a specified condition. Syntax: =DGET(database, field, criteria) Situation: This formula is suitable when...
Read More

CHOOSE

  • May 31, 2023
Definition: CHOOSE is a function that returns a value from a list of values based on a specified index. Syntax: =CHOOSE(index_num, value1, [value2], ...) Situation: This formula is...
Read More