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

Month: May 2023

ISFORMULA

  • May 31, 2023
Definition: ISFORMULA is a function that returns TRUE if a cell contains a formula, and FALSE if it does not. Syntax: =ISFORMULA(value) Situation: This formula is appropriate when...
Read More

ISEVEN

  • May 31, 2023
Definition: ISEVEN is a function that returns TRUE if a number is even, and FALSE if it is odd. Syntax: =ISEVEN(value) Situation: This formula is appropriate when you...
Read More

ISERROR

  • May 31, 2023
Definition: ISERROR is a function that returns TRUE if a value is any error value, including #N/A. Syntax: =ISERROR(value) Situation: This formula is appropriate when you need to...
Read More

ISERR

  • May 31, 2023
Definition: ISERR is a function that returns TRUE if a value is any error value except #N/A. Syntax: =ISERR(value) Situation: This formula is appropriate when you need to...
Read More

ISBLANK

  • May 31, 2023
Definition: ISBLANK is a function that returns TRUE if a cell is empty, and FALSE if it contains any value, including zero or a formula that returns an...
Read More

IPMT

  • May 31, 2023
Definition: IPMT is a function that calculates the interest payment for a given period of a loan or investment, assuming periodic, constant payments and a constant interest rate....
Read More

INTERCEPT

  • May 31, 2023
Definition: INTERCEPT is a function that returns the y-intercept of a linear regression line. Syntax: =INTERCEPT(known_y's, known_x's) Situation: This formula is suitable when you need to find the...
Read More

INT

  • May 31, 2023
Definition: INT is a function that rounds a number down to the nearest integer. Syntax: =INT(number) Situation: This formula is suitable when you need to round a number...
Read More

INFO

  • May 31, 2023
Definition: INFO is a function that returns information about the current operating environment. Syntax: =INFO(type_text) Situation: This formula is suitable when you need to obtain information about the...
Read More

INDIRECT

  • May 31, 2023
Definition: INDIRECT is a function that returns a reference to a range based on a text string. Syntax: =INDIRECT(ref_text, [a1]) Situation: This formula is suitable when you need...
Read More