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