mardi 10 mars 2020

Not getting expected results in IF statement, when referencing another cell also with an IF statement

Issue, I'm looking for a result in one cell based on results on another cell where both cells are using IF statements. The expected result is not displayed.

Example

Cell N14 is using a SUMIF formula to add the number of hours a person worked.

  • In this issue, the result is zero (0).
  • The result of the SUMIF on false is "", showing the cell blank

Formula

  • =SUMIFS([Column_Hours_Worked],[Column_Name],[Name],[Column_Date],[Date],"","")
  • The formula I know works, as seen in cell N13.

Cell O14 uses an IF statement, and returns an "X" if N14 is less than eight (8))

  • =IF(N14>=8,"","X")

The N14 cell seems to work fine, as I observe the cell is blank. - This is expected.

The O14 cell is not displaying the expected "X".

Troubleshooting

  • I can manually enter zero (0) into N14, which causes the expected "X" in O14.
  • I modified the SUMIF false result from blank ("") to ("0.0"), and did not see the expected "X" in O14.
    • O.O was observed in the N14 cell, as the SUMIF resulted in a false statement, or ("0.0")

Background

  • I've created a spreadsheet to track the number of hours people work on a given day.
  • I'd like to quickly identify when, in this example, less than 8 hours is worked.
  • N14 = The number of hours worked.
  • O14 = A flag ("X") at less than 8 hours.

Any suggestions?

Aucun commentaire:

Enregistrer un commentaire