Skip to main content
Web Applications

Return to Answer

added 39 characters in body
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them are visually very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done in a simpler way by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but "simpler" (from a "programming" point of view):

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them are visually very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but "simpler" (from a "programming" point of view):

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them are visually very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done in a simpler way by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but "simpler" (from a "programming" point of view):

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")
added 39 characters in body
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them visually are visually very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but simpler"simpler" (from a "programming" point of view):

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them visually are very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but simpler:

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them are visually very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but "simpler" (from a "programming" point of view):

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

Partial short answer

The formula in I4 has some syntax errors

  • Use of the wrong quotation character
  • Use of equal sign after commas

Also, the formulas in I3 and I4 have some programming errors:

  • Wrong references
  • "Unnecessary complexity"

Explanation

Syntax errors

Quotation marks

Modern applications use a large number of characters some of them visually are very similar like "(U+0022 QUOTATION MARK), ” (U+201D RIGHT DOUBLE QUOTATION MARK) and ʺ(U+02BA MODIFIER LETTER DOUBLE PRIME) but for technical purposes, like enclosing strings in spreadsheet formulas, " (U+0022 QUOTATION MARK) should be used. It's worth to say that some text processors like Microsoft Word could automatically replace " by ” so when using and external application as a helper to write complex formulas the related feature should be turned off.

Equal sign

The equal sign could be used as an operator in spreadsheet formulas at the beginning of a formula or as a comparison operator, but not after the function arguments separator (comma or semicolon, according to the spreadsheet locale settings)

Programming errors

Yes, writing a spreadsheet formula makes people to be programmers but usually they are called analysts or just spreadsheet users.

Wrong references

The formula in I4 include references to columns that don't exists (M4,K4,S4,L4)

Unnecessary complexity

The formulas in I3 and I4 use COUNTIF to do a comparisons and the add operator to check if all the required conditions are met. The same could be done by using comparison operators and the boolean functions. While complex ways to do things could work, when something fails, one thing to try is to reduce the complexity.

The following formula is equivalent to the I3 formula but simpler:

=IF(AND(D3<"9:31",E3>65,F3>65,G3>11,H3<"10:01"),"P","F")